Allow Charts to use data from hidden cells
As of now, if you group and/or hide cells that contain data going to a visualization, the visualization goes blank. I'd like to be able to hide data without losing the corresponding visual.
We actually support this feature in versions of Excel back to XL 2007. Here are the steps.
1) Select the chart
2) from the chart “Design” tab in the ribbon click on the button “Select Data”
3) In the dialog, click on the button called “Hidden and Empty Cells”
4) In the dialog, check the box called “Show data in hidden rows and columns”
Is this function also works in treemap? Tried but seems the option cannot be selected like other charts.
Jon Peltier commented
Actually, this has been supported at least since Excel 97.
In the data selection area there is an option called "Hidden and Empty Cells" in there you can tick "Show data in hidden rows and columns". I'm not sure if you meant automatically default to this as ticket or have this option added.