Showing and hiding series in charts

[Matt H]

Hi,
I have 7 data series in a column style chart. I would like to know if there
is a way to toggel each individual series on or off (hide or make visable)
similar to a pivot chart. I'm trying to print each series individually and
it's a pain to have to go and change the properties of the series every time
I want to hide one and view another. Thanks
Also, i'm using Excel 2003.

 

[Earl Kiosterud]

Matt,

One way is to hide the column (or row) that the series is plotted from. If it doesn't work,
select the chart, then Tools - Options - Chart tab, and make sure that "Plot visible cells
only" is checked. You could automate the hiding/showing pricess with macro buttons if
necessary.

 

[Jon Peltier]

Also answered in the charting group.

- Jon