Hidden Rows and Columns Visible, Color Coded, and Explained
(Slicers Deliberately Moved Aside for Clarity)
(Click for Larger Version)
A Most Popular Post Indeed!
Well the CalChart post was a hit – the second most popular post of this year in fact. (Second only to Dan Battagin’s spreadsheet formatting post, and that one had the benefit of being directly linked to from the official Excel blog – Dan is a big cheater).
I particularly enjoy how many Excel Pros are arriving at this blog for the first time as a result of the CalChart – you know who you are! You’re helpless against the luxuriant charms of the CalChart! 🙂
And you have to have PowerPivot for it to work, muhaha. Resistance is futile. Go download it from Microsoft now. It’s free.
Modifying it to fit your needs
The workbook I made available for download last week included a bunch of unused “machinery” – formulas and cells that I created while I was experimenting with different techniques, but ended up not using in the final version.