recreate a deleted LegendEntry

[xlrotor]

If an individual LegenEntry has been deleted from an xy chart, is
there a way to bring it back again?

I am finding that the entire legend has to be re-created from
scratch. Whereas I'd like to just undelete the one absent
LegendEntry.

Thanks,

Brian

 

[Leith Ross]

If an individual LegenEntry has been deleted from an xy chart, is
there a way to bring it back again?

I am finding that the entire legend has to be re-created from
scratch. Whereas I'd like to just undelete the one absent
LegendEntry.

Thanks,

Brian

Hello Brian,

Unfortunately, it is the only way to do it. Here is an excerpt from
the VBA Help files...
___________________________________________________________________________________________________

Remarks
There's no direct way to return the series or trendline corresponding
to the legend entry.

After legend entries have been deleted, the only way to restore them
is to remove and recreate the legend that contained them by setting
the HasLegend property for the chart to False and then back to True.
___________________________________________________________________________________________________

Sincerely,
Leith Ross

 

[xlrotor]

Thank you for pointing that out, Leith.

I completely missed that "remarks" section in the excel help file for
the LegendEntry object.

Brian