| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph changes to blank!!
When I hide the columns where the data is stored for a graph, the graph
becomes blank. The graph is on the same worksheet as the columns with the data. How do I still show the graph when the columns are hidden? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Graph changes to blank!!
Hi,
You need to uncheck the option Plot Visible Cells Only. Xl2003 or befo Select the chart and then use menus Tools Options Chart Plot Visible cells only. XL2007: Select the chart and use Chart Tools Design Select Data Hidden and Empty cells Show data in hidden rows and columns. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Joe M." wrote in message ... When I hide the columns where the data is stored for a graph, the graph becomes blank. The graph is on the same worksheet as the columns with the data. How do I still show the graph when the columns are hidden? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Graph changes to blank!!
Unhide the columns
Click on the chart to select it On the Tools menu, click on Options On the Chart tab, remove the check mark from Plot Visible Cells Only Click OK Joe M. wrote: When I hide the columns where the data is stored for a graph, the graph becomes blank. The graph is on the same worksheet as the columns with the data. How do I still show the graph when the columns are hidden? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Graph changes to blank!!
Ignore the first instruction (Unhide the columns)
Debra Dalgleish wrote: Unhide the columns Click on the chart to select it On the Tools menu, click on Options On the Chart tab, remove the check mark from Plot Visible Cells Only Click OK Joe M. wrote: When I hide the columns where the data is stored for a graph, the graph becomes blank. The graph is on the same worksheet as the columns with the data. How do I still show the graph when the columns are hidden? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Graph changes to blank!!
Why ignore? I Tried the earlier instruction to "remove the check mark from
Plot Visible Cells Only" and it worked. Thanks! "Debra Dalgleish" wrote: Ignore the first instruction (Unhide the columns) Debra Dalgleish wrote: Unhide the columns Click on the chart to select it On the Tools menu, click on Options On the Chart tab, remove the check mark from Plot Visible Cells Only Click OK Joe M. wrote: When I hide the columns where the data is stored for a graph, the graph becomes blank. The graph is on the same worksheet as the columns with the data. How do I still show the graph when the columns are hidden? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Graph changes to blank!!
Sorry, I meant that you could ignore the first line in my instructions,
which was "Unhide the columns" That step isn't necessary. Joe M. wrote: Why ignore? I Tried the earlier instruction to "remove the check mark from Plot Visible Cells Only" and it worked. Thanks! "Debra Dalgleish" wrote: Ignore the first instruction (Unhide the columns) Debra Dalgleish wrote: Unhide the columns Click on the chart to select it On the Tools menu, click on Options On the Chart tab, remove the check mark from Plot Visible Cells Only Click OK Joe M. wrote: When I hide the columns where the data is stored for a graph, the graph becomes blank. The graph is on the same worksheet as the columns with the data. How do I still show the graph when the columns are hidden? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank Graph After Hiding Cells | Excel Discussion (Misc queries) | |||
| Blank cells in graph | Charts and Charting in Excel | |||
| blank vs. 0 when plotting a dated timescale graph | Excel Worksheet Functions | |||
| How do I leave out blank cells in a line graph? | Charts and Charting in Excel | |||
| Do not want chart to graph cells with formulas that are "blank" | Charts and Charting in Excel | |||
Linear Mode
