Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to hide a chart series or make it invisible
I want to make some chart series invisible (hide them), and then later
restore them. Is there an easy way to do this without messing with a whole lot of chart series formatting properties? Thanks, Brian Murphy Austin, Texas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to hide a chart series or make it invisible
I may have answered my own question.
How about to hide a series redefine the Values property to point to some empty worksheet cells. Then to unhide restore the original Values property which I suppose could be a Range, Name or Array. Maybe save the Series.Formula property and use that to restore the Values property. Brian "Brian Murphy" wrote in message ... I want to make some chart series invisible (hide them), and then later restore them. Is there an easy way to do this without messing with a whole lot of chart series formatting properties? Thanks, Brian Murphy Austin, Texas |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to hide a chart series or make it invisible
If you just toggle the hidden status of the column or row
containing the source data it will hide/unhide the series. Ensure that the "Plot visible cells only" option is selected. Access this option through Tools|Options|Chart tab. Activate the chart first to enable the checkbox. Note that the Autofilter, by virtue of the fact that it hides/unhides rows, can thus be used to select the data to display. Regards, Greg -----Original Message----- I want to make some chart series invisible (hide them), and then later restore them. Is there an easy way to do this without messing with a whole lot of chart series formatting properties? Thanks, Brian Murphy Austin, Texas . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to hide a chart series or make it invisible
Hello Greg,
In my case there are logistical problems with hiding the column containing the data. Here's what I've done: 1. save the .Formula property for the series in a string variable. 2. reassign the .Values property to an empty cell. This hides the series. 3. To restore it I put a zero in the empty cell 4. reset the .Formula property using the saved string. 5. clear the zero from the cell I was using. This is working well through my testing so far. Brian "Greg Wilson" wrote in message ... If you just toggle the hidden status of the column or row containing the source data it will hide/unhide the series. Ensure that the "Plot visible cells only" option is selected. Access this option through Tools|Options|Chart tab. Activate the chart first to enable the checkbox. Note that the Autofilter, by virtue of the fact that it hides/unhides rows, can thus be used to select the data to display. Regards, Greg -----Original Message----- I want to make some chart series invisible (hide them), and then later restore them. Is there an easy way to do this without messing with a whole lot of chart series formatting properties? Thanks, Brian Murphy Austin, Texas . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a chart axis visible/invisible with VBA | Charts and Charting in Excel | |||
Hide data series in chart - toggle on and off | Charts and Charting in Excel | |||
How to make a checkbox on a chart invisible when it is clicked? | Charts and Charting in Excel | |||
How do I hide part of a data series in a chart? | Charts and Charting in Excel | |||
Make "Worksheet Menu Bar" invisible or Delete/hide it's buttons | Excel Programming |