Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart disappearing when source data hidden?
Why does the chart disappear when I hide the columns that the source
data is on? Thanks, Don <donwiss at panix.com. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart disappearing when source data hidden?
This is deliberate and allows you to hide or display data
using either the filter options (Data menu),subtotals or a macro to toggle the hidden status of the rows containing the chart data. You can unselect this option (i.e. diplay hidden data even if the rows are hidden) by first activating the chart and then selecting Tools|Options|Chart tab. Then unselect the "Plot visible cells only" checkbox. Regards, Greg -----Original Message----- Why does the chart disappear when I hide the columns that the source data is on? Thanks, Don <donwiss at panix.com. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disappearing Data Label in chart | Charts and Charting in Excel | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Line disappearing from chart after changing data source | Charts and Charting in Excel | |||
Hidden data - hidden chart | Charts and Charting in Excel | |||
Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) |