| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you graph data that is hidden?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you graph data that is hidden?
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PFLY" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
| Hidden data - hidden chart | Charts and Charting in Excel | |||
| Why are my hidden rows unhidden after I edit a graph? | Charts and Charting in Excel | |||
| HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) | |||
Linear Mode
