+ Reply to Thread
Results 1 to 5 of 5

Scattered Chart - Adding Data Labels to selected points

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Scattered Chart - Adding Data Labels to selected points

    Hello

    I need to add data labels to certain points on scattered chart. Due to a large number of data set - I need only selected points to have the value displayed.

    Looking for a VBA code PLEASE!

    Many thanks



    Label X_Axis Y_Axis Display Labels
    val1 $ 764 273 Yes
    val2 $ 6,542 67 No
    val3 $ 6,594 53 No
    val4 $ 2,227 276 Yes
    val5 $ 6,392 25 Yes
    val2 $ 3,688 235 No
    val7 $ 3,082 85 No
    val4 $ 2,876 46 Yes
    val5 $ 6,515 135 Yes
    val2 $ 9,131 285 No
    val7 $ 7,835 26 No
    val4 $ 1,790 55 Yes
    val5 $ 112 26 Yes
    val2 $ 9,071 22 No
    val7 $ 2,190 241 No
    val4 $ 3,265 78 Yes
    val5 $ 563 208 Yes
    val2 $ 1,118 211 No
    val7 $ 4,722 35 No
    val4 $ 9,016 126 Yes
    val5 $ 2,509 65 Yes

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Scattered Chart - Adding Data Labels to selected points

    Select the chart and run such sample code
    Please Login or Register  to view this content.
    adopt to your needs
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    02-26-2014
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Scattered Chart - Adding Data Labels to selected points

    Dziekuje.

    How can I display the values from the label column - i.e. val1, val2, etc?

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Scattered Chart - Adding Data Labels to selected points

    Cześć Marcin,

    Try such version:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-26-2014
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Scattered Chart - Adding Data Labels to selected points

    Dziekuje Panu!

+ 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. Excel 2007 : Labels for Data Points on a Scatter Chart
    By ProfessorDJF in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-12-2018, 12:47 PM
  2. Adding Labels to Data Points in Scatter Plot Chart
    By Stopea in forum Excel General
    Replies: 10
    Last Post: 05-21-2014, 08:25 PM
  3. Bilinear interpolation of scattered data points
    By Sebi in forum Excel General
    Replies: 15
    Last Post: 09-19-2012, 01:05 AM
  4. Add Labels to Chart Data points using Macro
    By dontuch_dg in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2009, 03:40 PM
  5. Replies: 0
    Last Post: 04-01-2009, 10:54 AM
  6. labels for chart data points
    By riwiseuse in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-01-2008, 03:44 PM
  7. Macro to add labels to data points in an xy scatter chart
    By Scott Wagner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-16-2005, 09:50 PM

Tags for this Thread

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