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.