Hide and unhide a serie
 

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

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

Hide and unhide a serie
 

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

"Jon Peltier" wrote:

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

Hide and unhide a serie
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


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

"Jon Peltier" wrote:

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