Repeat step 1 to 5 with remaining data labels.Ĭhange the value in cell D3 and see how the data label on the chart instantly changes.

The formula bar changes to perhaps =Sheet1!$D$3.

Use your mouse to press with left mouse button on a cell that contains the value you want to use.

Press with left mouse button on in formula bar.

Press with left mouse button on twice on a label to select it.

This workaround is for Excel 20, it is best for a small number of chart data points. Secondary Axis | Linear trendline | Logarithmic Trendline | Moving Average | Error Bars 2.

Press with left mouse button on 'Format Data Labels'Ĭustom-data-labels-in-a-x-y-scatter-chartv3.xlsx.

Press with right mouse button on on a data label.

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

Press with mouse on 'Change data label shapes'.īack to top 1.3 How to change data label locations.

Press with right mouse button on on a data label.

A new window appears to the right, deselect X and Y Value.

Press with right mouse button on on any dot again and press with left mouse button on 'Format Data Labels'.

Press with right mouse button on on a chart dot and press with left mouse button on on 'Add Data Labels'.

Press with left mouse button on the 'scatter' button.

The first 3 steps tell you how to build a scatter chart. This example chart shows the distance between the planets in our solar system, in an x y scatter chart. 1.1 How to apply custom data labels in Excel 2013 and later versions I will demonstrate how to do this for Excel 2013 and later versions and a workaround for earlier versions in this article.

They have implemented a feature into Excel 2013 that allows you to assign a cell to a chart data point label a, in an x y scatter chart. Luckily the people at Microsoft have heard our prayers.

How to apply custom data labels in Excel 2013 and later versions.

Data callout excel 2019 mac