+ Reply to Thread
Results 1 to 1 of 1

VBA to control chart legend entries

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    VBA to control chart legend entries

    Coming along well with my project to select any one of four aspects to display for any combination of 7 individuals but the legend is a nightmare. The legend entries are being retained so even after I delete a series the corresponding legend entry remains. If I add that individual's series back to the chart, a new legend entry is created and the old one remains still. Even if I manually select the entries and delete them, then refresh the chart or remove the legend entirely then bring it back, all those "ghost" entries still appear. Screenshot attached.

    Note: Any number or combination of names can be selected, but only one type by the radio buttons can be displayed at any time. The screenshot was after simply checking some of the names on and off several times. Legend entries just kept on accumulating instead of being automatically eliminated when I deleted a series. Do I have to take special action to get rid of an entry? It would seem strange as they were added automatically when I added a series...

    What are the rules/tricks/black magic spells used to control legends, or is there a good reasonable programmatically arrived at substitution?

    Many thanks-
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Set chart series color to match series legend entries font color
    By Equipoise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2013, 07:33 AM
  2. Replies: 2
    Last Post: 10-17-2011, 04:45 AM
  3. [SOLVED] Chart Legend Entries
    By BillCPA in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 06:32 PM
  4. Chart Legend - Order of Entries
    By Ron in forum Excel General
    Replies: 4
    Last Post: 06-07-2005, 09:05 AM
  5. [SOLVED] XY Chart with many curves: Independent legend entries?
    By Johannes Eble in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2005, 04:06 PM

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