Hidden data on graphs

[Guest]

I have charts on my spreadsheet that look fine until I
hide the columns that contain the plotted data and then
the graphs blank out. If I unhide the columns with the
data then the graphs come back into life. Any way around
this problem.
Thanks

 

[Andy Pope]

Hi tony,

Select the chart and then on the menus go to
Tools > Options
on the options dialog select the Chart tab.
Uncheck Plot visible cells only

You should now be able to hide columns and still keep the data in the chart.

I have charts on my spreadsheet that look fine until I
hide the columns that contain the plotted data and then
the graphs blank out. If I unhide the columns with the
data then the graphs come back into life. Any way around
this problem.
Thanks

--

Cheers
Andy

http://www.andypope.info