| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Blanks Out When I hide data column
I have a great chart on my worksheet, but when I hide the Column
of data that makes your it's data the Chart Goes BLANK. What must I do to be able to hide the column YET have the data reflected in the CHART? TIA, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart Blanks Out When I hide data column
Hi,
Select the chart, and choose Tools, Options, Chart tab, and make sure Plot visible cells only is not checked. If this helps, please click the Yes button Cheers, Shane Devenshire "JMay" wrote: I have a great chart on my worksheet, but when I hide the Column of data that makes your it's data the Chart Goes BLANK. What must I do to be able to hide the column YET have the data reflected in the CHART? TIA, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide the data label for a data table in a chart | Charts and Charting in Excel | |||
| How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
| How to hide blank rows after data whilst leaving some blanks. | New Users to Excel | |||
| Hide the tab with the data associated with a chart | Charts and Charting in Excel | |||
| hide column but show chart | Charts and Charting in Excel | |||
Hybrid Mode
