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


.