+ Reply to Thread
Results 1 to 3 of 3

Add legend titles beside lines in graph

  1. #1
    Registered User
    Join Date
    11-10-2005
    Location
    Scotland
    Posts
    69

    Add legend titles beside lines in graph

    Hi
    Excel 2007
    Is there a way to add a dynamic label beside a line in a line chart?
    I have attached an example to show what I mean.
    Currently I have used a text box to show the labels, but once I enter data in column Q or R, the graph line changes dynamically, but the text box remains in the current location.
    Is there a way to have the label names (Player 1 and Player 2) as dummy data points perhaps and have them off-set from the chart lines and move accordingly if the chart lines change position.
    Hope this makes sense.
    As usual, any advice is much appreciated
    Regards

    Craig
    Attached Files Attached Files
    Last edited by craigproudfoot; 10-19-2009 at 08:38 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Add legend titles beside lines in graph

    Add 2 more series where only the last value is plotted. Add data labels to the new series.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-10-2005
    Location
    Scotland
    Posts
    69

    Re: Add legend titles beside lines in graph

    Perfect

    Thanks

+ 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