Show/Hide series
 

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

Show/Hide series
 

I'm using Excel 2003. Thanks

"Matt H" wrote:

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

Show/Hide series
 

On Thu, 28 Feb 2008, in microsoft.public.excel.charting,
Matt H said:
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/

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Show/Hide series
 

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

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


"Matt H" wrote in message
...
I'm using Excel 2003. Thanks

"Matt H" wrote:

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

Show/Hide series
 

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

"Matt H" wrote:

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