+ Reply to Thread
Results 1 to 3 of 3

Add Data Labels, Show Series Names

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007,2010
    Posts
    27

    Question Add Data Labels, Show Series Names

    I have a scatter plot created using three columns:
    Column A = Series Name
    Column B = X Values
    Column C = Y Values

    I would like to show the data labels above the data points showing only the series all at once and not format each series individually.

    Any suggestion would be greatly appreciated.

    Thank you!
    Last edited by knightcloud; 03-18-2011 at 03:35 AM.

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

    Re: Add Data Labels, Show Series Names

    use this free addin to link data labels to cells.

    http://www.appspro.com/Utilities/ChartLabeler.htm
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007,2010
    Posts
    27

    Thumbs up Re: Add Data Labels, Show Series Names

    Thank you for your reply. This tool is a great help. I was also able to find this
    Please Login or Register  to view this content.

    Since the points in my chart are of different series, I wanted to show the series name all at once if the chart is updated. I'll try to incorporate this in my code for creating XYScatter Chart.

    Thank you again for your help.

+ 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