Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Add Text Box in Excel Graph (2 Simple Ways)

Creating graphs from data in Excel helps a lot with data analysis. Sometimes we want to add a text box to the graph which makes the graph and its element more comprehensible. In this article, I will show 2 simple ways to add a text box in Excel graph.


Download Practice Workbook

You can download the practice workbook from here.


2 Simple Ways to Add Text Box in Excel Graph

We can add a text box to any graph in Excel in different ways. In this section, I will show 2 simple ways to add a text box to a graph in Excel.

1. Use Insert Tab to Add Text Box in Excel Graph

In the first method, I will use the Inset tab of Excel ribbon to add a text box. For demonstration, I have used a dataset containing Subjects & Marks of a student’s test examination. Here, I have created a graph from the data on which I will add a text box.

Dataset:

how to add text box in excel graph

Graph:

Follow the stepwise procedures given below for adding a text box to the graph.

  • Firstly, go to the Insert tab.
  • Then, select Text. A drop-down menu will appear.
  • Select Text Box from there

Use Insert Tab to Add Text Box in Excel Graph

  • After that, move your mouse cursor on the graph, and the cursor pointer will change into a plus (+) sign.
  • Further, place the cursor on the desired palace of the graph.
  • Furthermore, hold left-click of the mouse and draw a box shape.
  • Thus, the text box is created.

  • Later on. click on the text box and write the text that you want to add.
  • Finally, we will see the text box is created with desired text inside.

Note: The text box we made is floating. It won’t change even if we change the position of the graph.

Read More: How to Insert an Embedded Text Box in Excel (4 Easy Ways)


2. Utilize Format Tab for Adding Text Box in Excel Chart

In the previous method, we added a text box to a graph. But the text box was floating which means it won’t move if we move the graph. We can easily fix the problem by using the Format tab. In this section, I will show the way to add a text box to a graph in Excel using the Format tab. For demonstration, I have used a dataset containing Subjects & Marks of a student’s test examination. Here, I have created a graph from the data on which I will add a text box.

Dataset:

Utilize Format Tab for Adding Text Box in Excel Chart

Graph:

Let’s walk through the procedures.

  • Firstly, select the graph and go to the Format tab.
  • Then, select Text Box from the ribbon.

  • Consecutively, the mouse cursor pointer will change into a plus (+) sign.
  • Further, place the cursor on the desired palace of the graph.
  • After that, hold left-click of the mouse and draw a rectangular box.
  • Thus, the text box is created.

  • Afterward, write the desired text in the box.
  • Finally, we have successfully added a text box to the graph in Excel.

how to add text box in excel graph result

  • In addition, we can do some formatting in the text box.
  • For that, select and rightclick on the text box.
  • Also, select Format Object from the appeared list.

  • Next, from the Format Shape pane, select Solid Line from Line option.

  • As a result, we will see a solid border around the text box.
  • Obviously, we can do more formatting in this way.

Read More: How to Edit Text Box in Excel (2 Simple Ways)


Importance of Adding Text Box to Excel Chart

  • The Text Box helps to identify different elements of a graph.
  • We can add special notes to the graph with the help of a text box.
  • We can identify the chart type and other features later on by using a text box.

Conclusion

A Text Box is quite helpful if we add it to a graph in Excel. Here, I have shown 2 simple ways to add a text box in Excel graph. Moreover, we have added the practice book at the beginning of the article. You can download it to practice by yourself. Lastly, If you have any queries or suggestions, please leave a comment. Visit our ExcelDemy Website for more articles regarding Excel.


Related Articles

Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo