Share via

Creating Scatter Plot with Marker Labels

Anonymous
2014-06-27T16:09:15+00:00

I have two columns of data that I'm creating a scatter plot with. I then want to use a third column to label my points. Excel doesn't seem to support this feature.

I want to make a chart like this.

http://support.sas.com/documentation/cdl/en/grstatgraph/66421/HTML/default/images/scatterplotintro.png

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2014-06-27T16:45:42+00:00

    Hi,

    Create your scatter chart using the 2 columns height and weight.

    Right click any data point and click 'Add data labels and Excel will pick one of the columns you used to create the chart.

    Right click one of these data labels and click 'Format data labels' and in the context menu that pops up select 'Value from cells' and select the column of names and click OK.

    Back in the context menu un-check the series that Excel chose as a data label and your done and end up with what looks like mine.

    40+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-06-27T17:02:57+00:00

    Thanks for the help. However, Excel 2013 does not have an option 'Value from cells.'

    The only options I have under "Label Options" are

    Series Name

    X value

    Y value

    Legend Key

    Separator

    Followed by label position.

    Hi,

    I'm using E2013 and mine does, see snip.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2014-06-27T16:56:20+00:00

    Thanks for the help. However, Excel 2013 does not have an option 'Value from cells.'

    The only options I have under "Label Options" are

    Series Name

    X value

    Y value

    Legend Key

    Separator

    Followed by label position.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2014-06-27T17:07:09+00:00

    actually the problem was i was using a .xls file and not xlsx so the option wasn't available.

    thanks.

    0 comments
  4. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2014-06-27T16:53:12+00:00

    Alternatively, use the chart labeler

    http://www.appspro.com/Utilities/ChartLabeler.htm

    0 comments