Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 a 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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel charts should allow "switching" series on or off
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 a 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Series equivalent in Excel 2000 | Charts and Charting in Excel | |||
Excel x,y chart type x range must be re-entered each series | Charts and Charting in Excel | |||
Disappearing scales on bar charts with multiple series | Charts and Charting in Excel | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |