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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Seemingly random plot area drift? 2
Graph Line Width ? 1
selecting and viewing a range 1
stacked column graph adjacent to a regular column graph 0
How do you not include 0 value data on a graph? 1
Remove a column but not data table entry 4
Excel Graph Problem - Need Help 2
Chart data from hidden rows (not columns) 1

Back
Top