Forum Discussion
chart percentages disappear when i hide rows, and the show data in hidden rows..unavailable
Hi all, I am working with multiple charts on one sheet; and trying to hide my data tables. all was well until I added percentage values to the end of a bar chart, and each time I hide the data, ...
DCasey400 I have the easiest solution. All you need to do is right-click the graph and select (Select Data). At the bottom left click the button that says "Hidden and Empty Cells". In the popup make sure "Show data in hidden rows and columns" is checked. That is all you need to do, now you can hide the data in your rows and columns without it affecting your chart.
bluenautica: Unfortunately, it's not that simple. In my case graphs only become visible when I tick the "Display hidden data" - no matter whether it was on or off! Weird.
