+ Reply to Thread
Results 1 to 7 of 7

How can i add data labels in the scatter graph?

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    ukraine
    MS-Off Ver
    Excel 2007
    Posts
    141

    How can i add data labels in the scatter graph?

    Hi All,
    Pls see attached relevent graph, i'll appricaite your help to add the names (column A) into the scatter of the data labels.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: How can i add data labels in the scatter graph?

    here's a little macro I use.

    Please Login or Register  to view this content.
    and here's the file too
    Attached Files Attached Files
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Contributor
    Join Date
    09-05-2012
    Location
    ukraine
    MS-Off Ver
    Excel 2007
    Posts
    141

    Re: How can i add data labels in the scatter graph?

    Thanks a lot. looks good!
    I'm not sure how can i update the name. for example, why the file isn't refreshing when i change A2 from a to w,
    Thanks a lot

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: How can i add data labels in the scatter graph?

    You need to select the chart then run the macro. It should update when you run the macro

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: How can i add data labels in the scatter graph?

    If you want to link the data labels to the cells, then select the chart and run this code once:
    Please Login or Register  to view this content.
    Then when you change the cells, the data labels should update automatically.

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: How can i add data labels in the scatter graph?

    If you are interested, rob bovey has written an add-in for this: www.appspro.com -- free utilities -- XY chart labeler add-in
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  7. #7
    Forum Contributor
    Join Date
    09-05-2012
    Location
    ukraine
    MS-Off Ver
    Excel 2007
    Posts
    141

    Re: How can i add data labels in the scatter graph?

    Thanks a lot

+ 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. Scatter Graph with Dates and Labels
    By Kyle123 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-05-2015, 05:34 AM
  2. Scatter graph labels issue
    By Number_8 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-13-2014, 06:19 AM
  3. Cant add data labels between two points on a scatter graph
    By jackelkes95 in forum Excel General
    Replies: 6
    Last Post: 09-22-2014, 08:19 AM
  4. Replies: 2
    Last Post: 04-05-2014, 06:46 PM
  5. Replies: 0
    Last Post: 06-15-2012, 03:23 PM
  6. scatter graph and marker labels with multiple series
    By tkotko123 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-01-2011, 05:29 PM
  7. [SOLVED] how can I automatically put labels in a scatter graph (.xls) ?
    By emilie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2005, 05:06 AM

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