Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

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.
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.
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
> _______
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.