+ Reply to Thread
Results 1 to 3 of 3

Scatter plot with labels

  1. #1
    Registered User
    Join Date
    08-08-2020
    Location
    Germany
    MS-Off Ver
    Excel for Mac
    Posts
    1

    Scatter plot with labels

    Hi,

    For a fictional manager game I am looking to track the performance (in points) of german soccer players in relation to their market value. By the end, I want to plot a trend line to analyse which players are currently under or overvalued on the market.

    Here an example with random numbers

    Player Points Market Value
    Player 1 20 500
    Player 2 70 1,200
    Player 3 100 2,800
    Player 4 140 3,900
    Player 5 200 5,100

    I figured that the scatter method might be probably the best way to identify the real value of the players. It is relatively easy to plot the "Points" on the x-axis and the "Market Value" on the y-axis. However, I am struggling to include the name of the players into the scatter dots. When I hover over the dots I want to see which player the data belongs to. Right now, I am only able to see the data for the x and y axis, and it all belongs to "Series 1". Is it possible to automatically create a new series for each player?

    In the internet, I found a lot of results where people are able to select the label through the option "Label Contains" --> "Value from Cells". In my excel version: Microsoft Excel for Mac, it is not able to select it. If anyone had an alternative for my analysis, I would very much appreciate it!

    Thanks in advance,
    Dektronary
    Last edited by Dektronary; 08-08-2020 at 06:21 AM.

  2. #2
    Registered User
    Join Date
    01-23-2020
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    22

    Re: Scatter plot with labels

    Right click on a chart dot and left click on "Add Data Labels" and then "Format Data Labels"

    In Label options, select option "Value from Cells" and then select Player's Range.

  3. #3
    Registered User
    Join Date
    01-23-2020
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    22

    Re: Scatter plot with labels

    sorry, did not read last bit of your post...


    There is a free add-in by Rob Bovey, called the XY Chart Labeler. The tool gives you a UI to insert and place labels.
    http://www.appspro.com/Utilities/ChartLabeler.htm

+ 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. xy-scatter diagram with labels
    By Jan Rennel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2014, 12:49 PM
  2. Replies: 2
    Last Post: 04-05-2014, 06:46 PM
  3. Replies: 2
    Last Post: 09-01-2010, 10:22 AM
  4. XY Scatter with Custom Labels
    By hatzipet in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2005, 12:05 AM
  5. xy scatter with third value labels?
    By Dennis in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-18-2005, 11:05 PM
  6. [SOLVED] Labels for Scatter Diagrams
    By ksn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-02-2005, 11:05 AM
  7. XY Scatter Map with Test Labels
    By Mike K. in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-24-2005, 03: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