How do you graph data that is hidden?

P

PFLY

I am trying to graph data and then hide the data. Every time i hide the
data, the graph goes blank. Is there a way to do this?
 
J

Jon Peltier

Excel 2003 and earlier: Select the chart, go to Tools menu > Options > Chart
tab, uncheck the box for Plot Visible Cells Only.

Excel 2007: Select the chart, find Select Data on the first charting tab,
look for a button in the lower left corner of the dialog, I forget what it's
called, but it opens a small dialog where you can change the setting.

- Jon
 

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

Graph changes to blank!! 5
Blank Graph After Hiding Cells 4
Line Graph Excluding 0 Values 6
Copy Graph But change Data Sheet 1
Can blank cells be omitted from graph? 7
graphing data only in a certain range 2
Scale of Graph Axis 2
Excel How to create a stacked bar graph 0

Top