I did a post on the Pie in Pie chart a few weeks back, but it can be a bit clunky to use. I thought about using a few dynamic array functions to make it a bit more interactive and flexible. The source data is in a formatted table called Table1. In a separate sheet there are two input cells. One for the state to report on and the other to enter the number of “main” segments to use. The…
Like me, you have no doubt seen some colourful Excel files. One task that colour is used for is to mark rows so they can be reviewed. In general, please avoid applying colours manually when marking rows for review. Instead use a code in a separate column.
(more…)
Excel has plenty of issues when it comes to correctly handling blank cells. Here is a solution to one of those issues.
(more…)
Pie charts often get a bad rap in data visualisation circles (sorry) but here is a technique to avoid those multiple small segments.
(more…)