Article updated on February 05, 2018

I demonstrated in a post from March 2013 how to create Custom data labels in a chart. Unfortunately, that technique worked only for bar and column charts, you can't apply the same technique for an x y scatter chart, as far as I know.

This following video shows you how to add data labels in an X Y Scatter Chart [Excel 2013 and later versions].


Luckily the people at Microsoft have heard our prayers. They have implemented a feature into Excel 2013 to label a value from cells, in an x y scatter chart. In fact, I think you can label a value from cells in most chart types.

This example chart shows the distance between the planets in our solar system, in an x y scatter chart.

x y scatter chart - custom data labels3

How to apply custom data labels in excel 2013

The first 3 steps tells you how to build a scatter chart.

  1. Select cell range B3:C11
  2. Go to tab "Insert"
  3. Click the "scatter" button
  4. Right click on a chart dot and left click on "Add Data Labels"
  5. Right click on a dot again and left click "Format Data Labels"
  6. A new window appears to the right, deselect X and Y Value.
    Format data labels excel 2013
  7. Enable "Value from cells"
    data label range excel 2013
  8. Select cell range D3:D11
  9. Click OK

This is what the chart shows, as you can see you need to manually rearrange the data labels and add data label shapes.

x y scatter chart excel 365

Recommended articles

How to create an horizontal line in a chart

This tutorial shows you how to add a line to a chart, it combines two types of charts, column and scatter […]

Add pictures to a chart axis

This picture below shows you a column chart with pictures (flags) below each column. Watch this video to learn how […]

How to add data label shapes

  1. Right click on a data label
  2. Click on "Change data label shapes"
  3. Select a shape

How to rearrange data labels

You can manually click and drag data labels as needed. You can also let excel change the position of all data labels, choose between center, left, right, above and below.

  1. Right click on a data label
  2. Click "Format Data Labels"
    Change label position excel 13
  3. Select a new label position.

Download excel 2013 *.xlsx file

Custom data labels in a x y scatter chartv2.xlsx

Recommended chart tutorials

How to create a dynamic chart

Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]

Dynamic Gantt charts in excel 2007

Today I am going to show you how to create a dynamic Gantt chart in excel 2007. A Gantt chart helps […]

Format fill color on a column chart based on cell color

Table of contents Format fill color on a column chart based on cell color Change stacked bar colors Mark Graveson […]

Workaround for Excel 2010 and previous versions

Add custom data labels in a x y scatter chart1

This workaround is alright if your data set is small.

  1. Make sure you select a single data label
  2. Click on formula bar
  3. Type =
  4. Use your mouse to click on a cell that contains the value you want to use.
  5. Repeat step 1 to  4 with remaining data labels

Change the value in cell D3 and see how the data label on the chart instantly changes.