Excel charts should allow "switching" series on or off

A plot (chart) of time series data may be used for many purposes. From my
use two reasons I use such plots are:
Studying individual time series trends; and
Overall impression of all results.

But when studying multiple time series data a chart can become cluttered.
It would be useful if individual series could be seleceted as visible or
invisible so that they could be evaluated without losing the total plot.

At the moment the only way to "unclutter" the plot is to remove the
temporaily-unwanted series but it can be time consuming to reconstruct the
plot.

----------------
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/comm...excel.charting

Hi,

You might find Jon Peltier's example of selecting series to plot via
checkboxes helpful, rather than deleting series from the chart.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

Robert wrote:
> A plot (chart) of time series data may be used for many purposes. From my
> use two reasons I use such plots are:
> Studying individual time series trends; and
> Overall impression of all results.
>
> But when studying multiple time series data a chart can become cluttered.
> It would be useful if individual series could be seleceted as visible or
> invisible so that they could be evaluated without losing the total plot.
>
> At the moment the only way to "unclutter" the plot is to remove the
> temporaily-unwanted series but it can be time consuming to reconstruct the
> plot.
>
> ----------------
> 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/comm...excel.charting

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info