Richard Ahlvin wrote:

You could write a macro which hides and restores the legend based on the
visibility of the series.

This is an approach I could try; But I have not found the chart object; it
appears to be a script and not a VBA object. I think I could figgure it out
in VBA, but I'm not familiar with the scripting (which I thought was
obsolete!) I have been able to copy a complicated chart and change its
source data by making the chart a separate sheet, going to the script, then
using find/replace to change the data sheet name, then move the chart back
to the desired location.

Richard -

What do you mean by "scripting"? Are you referring to the SERIES formula
in the formula bar, when the series is selected?

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