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

Get FREE Advanced Excel Exercises with Solutions!

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 to an 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. Using Insert Tab to Add Text Box in Excel Graph

In the first method, I will use the Inset tab of the Excel ribbon to add a text box. For demonstration, I have used a dataset containing subjects and 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 the 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 the 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 Add a Dynamic Text Box in Excel


2. Utilizing 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 and 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 the 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 right-click on the text box.
  • Also, select Format Object from the appeared list.

  • Next, from the Format Shape pane, select Solid Line from the 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 Insert Scrolling Text Box in Excel


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.

Download Practice Workbook

You can download the practice workbook from here.


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 an 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.


Related Articles


<< Go Back to TextBox | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan Shimul
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo