Re: Allow show/hide option for Excel graph series
- From: "Jon Peltier" <jonxlmvpNO@xxxxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Aug 2007 14:51:09 -0400
You could use checkboxes linked to each series to make it easy to show or
hide certain ones:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Margaret from Michigan" <Margaret from Michigan@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:B23488AD-C6CB-412A-B684-2BEAA7D4A8C3@xxxxxxxxxxxxxxxx
To plot a graph with multiple series in Excel, I need to "Add" each series
the Source Data window. When I get to several series (5+), it gets
to organize the graph. I would like to select specific series to show and
deselect specific series to hide, all at my choosing. This would make it
very easy to show comparisons between Series A and B, followed by a
comparison in Series B and C, etc. Meanwhile, I could have a few series
permanently shown on the graph as reference data.
As it is now, in order to make the comparisons, I have to create several
different graphs or I have to add and remove series within the same graph.
Adding a series requires selecting the data columns from the spreadsheet;
the spreadsheet is large, this can be a big pain to do over and over
Both methods are a hassle and not efficient for the user. Please add
click-able hide/show options.