Hidden data on graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top