| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Show/Hide series
Hi,
I have 7 data series in a column style chart. I would like to know if there is a way to toggel each individual series on or off (hide or make visable) similar to a pivot chart. I'm trying to print each series individually and it's a pain to have to go and change the properties of the series every time I want to hide one and view another. Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Show/Hide series
I'm using Excel 2003. Thanks
"Matt H" wrote: Hi, I have 7 data series in a column style chart. I would like to know if there is a way to toggel each individual series on or off (hide or make visable) similar to a pivot chart. I'm trying to print each series individually and it's a pain to have to go and change the properties of the series every time I want to hide one and view another. Thanks |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Show/Hide series
On Thu, 28 Feb 2008, in microsoft.public.excel.charting,
Matt H said: I have 7 data series in a column style chart. I would like to know if there is a way to toggel each individual series on or off (hide or make visable) similar to a pivot chart. I'm trying to print each series individually and it's a pain to have to go and change the properties of the series every time I want to hide one and view another. Have a look at this article: http://www.juiceanalytics.com/ writing/2007/05/why-make-100-charts-when-one-will-do/ -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Show/Hide series
http://peltiertech.com/Excel/Charts/ChartByControl.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Matt H" wrote in message ... I'm using Excel 2003. Thanks "Matt H" wrote: Hi, I have 7 data series in a column style chart. I would like to know if there is a way to toggel each individual series on or off (hide or make visable) similar to a pivot chart. I'm trying to print each series individually and it's a pain to have to go and change the properties of the series every time I want to hide one and view another. Thanks |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Show/Hide series
Just hide the columns/rows on the worksheet you don't want appearing on the
chart. "Matt H" wrote: Hi, I have 7 data series in a column style chart. I would like to know if there is a way to toggel each individual series on or off (hide or make visable) similar to a pivot chart. I'm trying to print each series individually and it's a pain to have to go and change the properties of the series every time I want to hide one and view another. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide legend for #N/A series | Charts and Charting in Excel | |||
| show/hide multiple series using named ranges | Charts and Charting in Excel | |||
| hide or show a series with a button | Charts and Charting in Excel | |||
| Allow show/hide option for Excel graph series | Charts and Charting in Excel | |||
| How do I hide part of a data series in a chart? | Charts and Charting in Excel | |||
Linear Mode
