Hide and unhide a serie

[matelot]

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

 

[Jon Peltier]

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

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

- Jon

 

[matelot]

That's great. However, the legend on the side always show the 3 series.
Anyway to remove the unchecked serie?

 

[Jon Peltier]

There's no codeless dynamic way to remove these legend entries. You could
rely on a data label on (for example) the last point of each series. In a
line or XY chart, if the point is based on a blank cell or a #N/A value, it
will not plot and you will not get a data label. In a column or other chart
type, the points are still there, represented by zero values, but if you use
a dynamic named range for the series name, and point it at a blank cell, the
label will be there but will not display any text.

- Jon