Allow show/hide option for Excel graph series

To plot a graph with multiple series in Excel, I need to "Add" each series in
the Source Data window. When I get to several series (5+), it gets difficult
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; if
the spreadsheet is large, this can be a big pain to do over and over again.
Both methods are a hassle and not efficient for the user. Please add
click-able hide/show options.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com....excel.charting

Margaret -

You could use checkboxes linked to each series to make it easy to show or
hide certain ones:

http://peltiertech.com/Excel/Charts/ChartByControl.html

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


"Margaret from Michigan" <Margaret from Michigan@discussions.microsoft.com>
wrote in message news:B23488AD-C6CB-412A-B684-2BEAA7D4A8C3@microsoft.com...
> To plot a graph with multiple series in Excel, I need to "Add" each series
> in
> the Source Data window. When I get to several series (5+), it gets
> difficult
> 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;
> if
> the spreadsheet is large, this can be a big pain to do over and over
> again.
> Both methods are a hassle and not efficient for the user. Please add
> click-able hide/show options.