Showing and hiding series in charts
 

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.

Showing and hiding series in charts
 

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.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Matt H" wrote in message
...
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.

Showing and hiding series in charts
 

Also answered in the charting group.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Matt H" wrote in message
...
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.