Hide data series in chart - toggle on and off

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stef - 03 Oct 2007 20:32 GMT

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.

Reply to this Message

Jon Peltier - 03 Oct 2007 20:43 GMT

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
_______

> Excel 2002 SP3
> Win XP HE
[quoted text clipped - 9 lines]
> I am really trying to fix scaling problems....
> Thanks.

Reply to this Message

stef - 03 Oct 2007 20:49 GMT

Thanks!

> One of the examples in the page below shows how to show and hide chart
> series using checkboxes:
[quoted text clipped - 7 lines]
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______

Reply to this Message