View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Hide and unhide a serie

This way doesn't use macros, just some simple checkboxes:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"matelot" wrote in message
...
I have a line graph with 4 series. Depending on the selection made, I would
like to hide or unhide 1 or 2 series using macro. Is it possible? I tried
manually and it always delete the entire serie rather than hiding it.

Thanks