| Home |
| Search |
| Today's Posts |
|
#1
December 13th 06, 05:01 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Best way to "turn off" a data series on a chart?
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. |
|
#2
December 13th 06, 05:40 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Best way to "turn off" a data series on a chart?
CodeKid:
There are several ways to do this. The "best" way depends on your user interface needs. Here's an example using checkboxes. http://processtrends.com/pg_interact...checkboxes.htm A second example lets user both scroll data and select series: http://processtrends.com/pg_chart_sc...r_checkbox.htm I have several videos that show more elaborate techniques. Kelly e-mail: koday AT processtrends DOT 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. |
|
#3
December 13th 06, 06:00 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#4
December 13th 06, 06:58 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Best way to "turn off" a data series on a chart?
As usual, Peltier = Grand Master of Charts
 Thanks again for your assistance, Jon. "Jon Peltier" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
| Selecting part of a series for a chart? | Charts and Charting in Excel | |||
| Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
| Can I overlap only two of four data series in Excel Column Chart? | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
