text labels on Excel scatter chart axis

How to add text labels on Excel scatter chart axis

By default, you can not add text labels on Excel scatter chart axis, but here is a workaround that allows you to do that. You can change Excel scatter chart horizontal or vertical axis labels using a dummy series. Here is how to do that in a few simple steps.

 

Here is the data that I would like to display in the Excel scatter chart. In addition, I would like to add custom labels on Excel scatter chart x-axis with each person’s name.

Excel scatter plot data

Stepps to add text labels on Excel scatter chart axis

1. Firstly it is not straightforward. Excel scatter chart does not group data by text. Create a numerical representation for each category like this.

By visualizing both numerical columns, it works as suspected. The scatter chart groups data points.

basic Excel scatter chart

2. Secondly, create two additional columns.

The first column contains dummy series that will be used to add text labels on Excel scatter chart axis. Values are equal to the crossing point with the y axis. In my case, it is zero.
The second column contains labels that replace dummy series values – only one for each category to avoid overlapping.

dummy data for Excel scatter chart axis labels

3. Add dummy series to the scatter plot and add data labels.

Excel scatter chart with dummy series

4. Select recently added labels and press Ctrl + 1 to edit them. Add custom data labels from the column “X axis labels”. Use “Values from Cells” like in this other post and remove values related to the actual dummy series. Change the label position below data points. Hide dummy data series markers by switching marker options to none.

Excel scatter chart with edited dummy series

5. Select actual x-axis labels, press Ctrl + 1, and use format code to make them invisible.

Excel format code to hide chart labels

That is how you can add custom categories on Excel scatter chart axis.

Excel scatter-chart-with-text-on-axis

It can be a vertical axis, horizontal, or both of them. Be aware of other customizations that might be necessary, like axis minimum, maximum or major units.

 

You can download the file with the resultĀ right here.

A scatter chart in Excel can be a stepping stone for unusual visualizations like magic quadrant charts.