+ Reply to Thread
Results 1 to 7 of 7

Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 2010

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Middle East
    MS-Off Ver
    Excel 2010
    Posts
    60

    Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 2010

    Hi everyone,

    Is there a way to add ONE OCCURRENCE of the series data label on each line in a line chart in EXCEL 2010?

    I'd like to have a graph line chart that above only every line, the series name will appear above. In the attached sample, I had to write using a text box the series name above the upper line.

    I noticed that it is possible to add one data label to a line (like the $0.52 in the sample), but when trying to display the series instead of the data label, all the points on the line show the data series name instead of only one point (like the 'Base' line in the attached sample).


    Does anyone know how to solve it?


    Thank you,

    Moty
    Attached Files Attached Files

  2. #2
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 20

    I don't understand the post. Can you provide amplifying info?

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    Middle East
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 20

    I attach another excel file which shows what I mean.
    Attached Files Attached Files

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

    Re: Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 20

    Maybe this approach would work for you.
    http://www.dailydoseofexcel.com/arch...t-data-labels/

    Other wise a non vba approach would be adding duplicate data series for each existing series with only 1 valid data point.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor ptm0412's Avatar
    Join Date
    04-16-2008
    Location
    Vietnam
    MS-Off Ver
    Office 2003 and 2007
    Posts
    129

    Re: Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 20

    Firstly, you click on the serie to select the whole serie.
    Then click once on the point that you want to add label
    Now, format that single point to add label with serie name.

    The difference is on the title of the dialog box: "Format data point" instead of "Format data serie"

  6. #6
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 20

    Here's my attempt at what you're trying to achieve by following the instruction in ptm0412s post.

    Oh, and I removed the original chart legend to avoid redundancy.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-15-2012
    Location
    Middle East
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 20

    I see. Thank you all 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