Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recreate a deleted LegendEntry
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
recreate a deleted LegendEntry
On Mar 18, 12:36 pm, xlrotor wrote:
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
recreate a deleted LegendEntry
Thank you for pointing that out, Leith.
I completely missed that "remarks" section in the excel help file for the LegendEntry object. Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete a specific LegendEntry? | Charts and Charting in Excel | |||
Recreate Data Validation | Excel Programming | |||
Recreate AutoScroll | Excel Programming | |||
Can't recreate A Macro | Excel Programming | |||
Recreate a macro menu | Excel Programming |