+ Reply to Thread
Results 1 to 3 of 3

Add data label to mean line

  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Add data label to mean line

    I have used the method below to add a mean line to my chart, but if I turn on the data labels I will get mutiple points. Any way to just get one label for the line and maybe to the side of the line?

    http://www.tushar-mehta.com/excel/ch...nes/index.html
    Last edited by jeffreybrown; 03-12-2011 at 12:07 PM.
    HTH
    Regards, Jeff

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

    Re: Add data label to mean line

    you could select the series and select a the last point and then apply data labels to that single point.

    Set Position of data label to Right
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Add data label to mean line

    It never crossed my mind to use just one data label...Thanks Andy

+ 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