+ Reply to Thread
Results 1 to 3 of 3

Use data labels in legend with X Y scatter chart

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2010
    Posts
    69

    Use data labels in legend with X Y scatter chart

    Hi,

    I have a scatter chart with data labels. To add the data labels, I use this VBA code form microsoft:

    Please Login or Register  to view this content.
    This works perfectly but what I actually want is the labels to be in a legend and for each label a different color..

    Any help is much appreciated!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,345

    Re: Use data labels in legend with X Y scatter chart

    It is not clear to me what you want to do. Jon Peltier has a series of essays on his site that describe several different aspects and tricks for working with legends (first in the series: http://peltiertech.com/legends-excel...hape-position/ links to follow up posts at the bottom of the essay). You might look through those and see if his ideas point you in the right direction.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-18-2015
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2010
    Posts
    69

    Re: Use data labels in legend with X Y scatter chart

    Many thanks!

+ 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. Using VBA to move data labels positions in a scatter chart
    By lafer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2014, 04:31 AM
  2. [SOLVED] Exclude one data series from scatter chart legend (but not from the chart)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 05:24 PM
  3. Replies: 2
    Last Post: 10-17-2011, 04:45 AM
  4. [SOLVED] 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
  5. Data point labels in XY scatter chart
    By TonyGB007 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2005, 05:20 AM
  6. [SOLVED] Data labels on scatter chart
    By rmellison in forum Excel General
    Replies: 3
    Last Post: 10-18-2005, 11:05 AM
  7. Excel 2000 Scatter Chart cannot use data labels
    By Tom in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2005, 02:06 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