5.5 C
London
Saturday, December 28, 2024
HomeSoftware TutorialsExcelHow to Add Labels to Scatterplot Points in Excel

How to Add Labels to Scatterplot Points in Excel

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

Often you may want to add labels to scatterplot points in Excel, such as in the scatterplot below:

Excel scatterplot with labels on points

Fortunately this is fairly easy to do in Excel and the following step-by-step example shows exactly how.

Step 1: Create the Data

First, let’s create the following dataset that shows (X, Y) coordinates for eight different groups:

Step 2: Create the Scatterplot

Next, highlight the cells in the range B2:C9. Then, click the Insert tab along the top ribbon and click the Insert Scatter (X,Y) option in the Charts group.

The following scatterplot will appear:

Step 3: Add Labels to Points

Next, click anywhere on the chart until a green plus (+) sign appears in the top right corner. Then click Data Labels, then click More Options…

In the Format Data Labels window that appears on the right of the screen, uncheck the box next to Y Value and check the box next to Value From Cells

In the window that appears, choose A2:A9 as the Data Label Range:

Once you click OK, the following labels will automatically appear next to the scatterplot points:

Feel free to click on the labels to modify their style or increase their font size:

Additional Resources

The following tutorials explain how to perform other common functions with scatterplots in Excel:

How to Create a Scatterplot with Multiple Series in Excel
How to Add a Regression Line to a Scatterplot in Excel
How to Add a Horizontal Line to a Scatterplot in Excel

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories