View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Best way to "turn off" a data series on a chart?

Hide the ranges containing the data for the unwanted rows, either manually
or using an Autofilter.

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


"CodeKid" wrote in message
...
I have a chart that has 3 different series of data on it and I'd like to be
able to turn several of them "on and off", essentialy removing them from
the
chart temporarily. What the best way to do this?

Many thanks for your assistance.