One of the examples in the page below shows how to show and hide chart
series using checkboxes:
http://peltiertech.com/Excel/Charts/ChartByControl.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"stef" wrote in message
...
Excel 2002 SP3
Win XP HE
*Follow-up to: microsoft.public.excel.charting*
Hi,
I have a chart with 3 series. 2 are on right axis (secondary) and 1 on
left (primary).
Is it possible for me to toggle on or off 1 of the series?
I cannot just hide it by choosing "none" as plot data as it still plots it
even if not visible.
I am really trying to fix scaling problems....
Thanks.