How to Add Text to Scatter Plot in Excel (2 Easy Ways)

Last updated: February 7, 2023
Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to know how to add text to scatter plot in Excel? Scatter Plots are really useful while representing the correlation between two numerical values. Sometimes, we need to add text to explain the chart more precisely. Here, you will find step-by-step explained ways to add text to scatter plot in Excel.


Download Practice Workbook


2 Ways to Add Text to Scatter Plot in Excel

Here, we have a dataset containing the Name, Height in cm, and Weight in kg of some students. We will show you how to add text to the corresponding Scatter Plot.

Add Text to Scatter Plot in Excel


1. Using Text Box Command to Add Text to Scatter Plot in Excel

In the first method, we will show you how to add text to a scatter plot in Excel using Text Box. You can add a Text Box in the scatter plot anywhere we want.

Follow the steps given below to do it on your own.

Steps:

  • First, select Cell range C5:D12.
  • Then, go to the Insert tab >> click on Scatter Chart.

Using Text Box to Add Text to Scatter Plot in Excel

  • After that, select the Scatter Plot without any lines.

  • Now, a Scatter Plot will appear containing the data of Heights as X-axis and Weights as Y-axis.
  • Next, double-click on the X-axis.

Using Text Box to Add Text to Scatter Plot in Excel

  • After that, the Format Axis toolbar will open.
  • Then, from Axis Options >> change the Minimum value as 145 and the Maximum value as 185.

  • Next, double-click on the Y-axis.

Using Text Box to Add Text to Scatter Plot in Excel

  • Now, the Format Axis toolbar will appear again.
  • After that, from Axis Options >> change the Minimum value as 45 and the Maximum value as 85.

  • Then, click on the Chart Title to change it.

Using Text Box to Add Text to Scatter Plot in Excel

  • Afterward, change the Chart Title as Height & Weight of Students.

  • Next, click on the “+” sign to open the Chart Elements.
  • Then, turn off the Gridlines.
  • After that, click on the Axis Titles to add the tiles for both of the axes.

Using Text Box to Add Text to Scatter Plot in Excel

  • Now, type Height (cm) as the title of X-axis.

  • Then, type Weight (kg) as the title of Y-axis.

Using Text Box to Add Text to Scatter Plot in Excel

  • Thus, you will get the corresponding Scatter Plot for the dataset.

Using Text Box to Add Text to Scatter Plot in Excel

  • After that, select the Scatter Plot.
  • Then, go to the Insert tab >> click on Text >> select Text Box.

  • Now, enter a Text Box into the Scatter Plot.

Using Text Box to Add Text to Scatter Plot in Excel

  • Next, type the corresponding data of the data point in your Scatter Plot. Here, we will type Mary, 148cm, 54kg as the corresponding data of the data point.

  • Then, add the other values of the data points using Text Box following the same steps.
  •  Finally, you will get your desired Scatter Plot with texts using Text Box.

Using Text Box to Add Text to Scatter Plot in Excel

Read More: How to Make a Scatter Plot in Excel with Two Sets of Data (in Easy Steps)


Similar Readings


2. Use of Format Data Labels to Add Text to Scatter Plot in Excel

We can also add text to scatter plots using Format Data Labels in Excel. Go through the steps to do it on your own dataset.

Steps:

  • First, follow the steps done in Method 1 to plot Scatter Plot for your dataset.

Use of Format Data Labels in Excel

  • Then, click on the “+” sign to open the Chart Elements.
  • After that, turn on Data Labels >> select More Options.

  • Now, the Format Data Labels tool box will open.
  • Next, turn on the X Value option.
  • Then, click on Value From Cells.

Use of Format Data Labels in Excel

  • Afterward, the Data Label Range box will appear.
  • Next, insert Cell range B5:B12 in the Select Data Label Range box.
  • Then, press OK.

  • Finally, you will get your desired Scatter Plot with text labels using Format Data Labels.

Use of Format Data Labels in Excel

Read More: How to Add Data Labels to Scatter Plot in Excel (2 Easy Ways)


Things to Remember

  • Make sure that you have selected the scatter plot before adding text, otherwise, the text will not move if the scatter plot is moved.

Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find a step-by-step way to add text to scatter plots in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin Islam
Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo