+ Reply to Thread
Results 1 to 2 of 2

Question about LegendEntry

  1. #1
    Registered User
    Join Date
    02-21-2007
    Posts
    4

    Question about LegendEntry

    Hello,

    When working on a chart with VBA, you can delete a the legend entry with the following command:
    ActiveChart.Legend.LegendEntries(1).Delete
    without deleting the corresponding plot.

    My question is: how do you recreate the legend entry with VBA ?
    Is there a property like Visible = True or Visible = False rather than delete it ?

    Any help on this could be really great.
    Thanks

  2. #2
    Registered User
    Join Date
    02-21-2007
    Posts
    4
    Me again... I think there isn't any solution to my problem:
    I found this:
    http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1