Show/Hide series

[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

 

[Matt H]

I'm using Excel 2003. Thanks

 

[Del Cotter]

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.

Have a look at this article:

http://www.juiceanalytics.com/
writing/2007/05/why-make-100-charts-when-one-will-do/

 

[Jon Peltier]

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon

 

[Mike]

Just hide the columns/rows on the worksheet you don't want appearing on the
chart.