Chart legends and VBA

[kenreavy]

Hi

I know how to delete a legend entry using vba

ActiveChart.Legend.LegendEntries(2).Select
Selection.Delete

but is it possible to add legends is a similar way?

Thanks

 

[Damon Ostrander]

Hi kenreavy,

This is what the VBA helps say regarding restoring deleted LegendEntries:

"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."

I hope this helps.

Damon