Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing and hiding series in charts
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 Also, i'm using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing and hiding series in charts
Matt,
One way is to hide the column (or row) that the series is plotted from. If it doesn't work, select the chart, then Tools - Options - Chart tab, and make sure that "Plot visible cells only" is checked. You could automate the hiding/showing pricess with macro buttons if necessary. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Matt H" wrote in message ... 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 Also, i'm using Excel 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing and hiding series in charts
Also answered in the charting group.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Matt H" wrote in message ... 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 Also, i'm using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding/Showing Rows on Cell H2 Change | Excel Discussion (Misc queries) | |||
Conditionally Hiding or Showing the cell content | Excel Discussion (Misc queries) | |||
Charts switch from 'Series in Rows' to 'Series in Columns' | Charts and Charting in Excel | |||
hiding and showing graphs | Excel Worksheet Functions | |||
Protected worksheet, showing and hiding Grouped detail | Excel Discussion (Misc queries) |