Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart disappears when source data cells are hidden
I have charts linked to source data cells that I would like to hide. However,
whenever I try to hide the cells associated with, for example, data labels on the chart, the labels disappear. And when I hide all of the data associated with a chart, the entire chart disappears. Any thoughts? Thanks. |
#2
|
|||
|
|||
Put the data on a separate sheet and hide that sheet.
If you want it to be REALLY secure use a macro with veryhidden and protect your macros with a password. -- Don Guillett SalesAid Software "Disappearing charts" <Disappearing wrote in message ... I have charts linked to source data cells that I would like to hide. However, whenever I try to hide the cells associated with, for example, data labels on the chart, the labels disappear. And when I hide all of the data associated with a chart, the entire chart disappears. Any thoughts? Thanks. |
#3
|
|||
|
|||
Select the chart
Choose ToolsOptions Select the Chart tab Remove the check mark from "Plot visible cells only" Click OK Disappearing charts wrote: I have charts linked to source data cells that I would like to hide. However, whenever I try to hide the cells associated with, for example, data labels on the chart, the labels disappear. And when I hide all of the data associated with a chart, the entire chart disappears. Any thoughts? Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Formulas in source data | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |