Insert Textbox to a Chart – Excel & Google Sheets

In this tutorial, we will demonstrate how to add a textbox to a graph in Excel and Google Sheets.

Adding a Textbox to a Graph in Excel

Starting with your Graph

We’ll start with the below graph. As you can see, there is a large increase in Month 11. In this scenario, we’ll show how to add a textbox to the graph.

 

Add Textbox in a Graph Chart in Excel

 

Adding Textbox

  1. Click Insert
  2. Select Text
  3. Click Text Box

Insert Textbox to Graph Chart in Excel

 

4. Drag where you would like the textbox to be

Create Textbox on Line Graph Chart Excel

 

Final Textbox on Graph

After typing in the Text Box and formatting it as appropriate, you will have a final textbox that helps gives key information about the graph.

Final Textbox on Graph Chart in Excel

 

Adding a Textbox to a Graph in Google Sheets

Using the same data from the Excel tutorial, we’ll add a textbox to the graph in Google Sheets

  1. Click Insert
  2. Select Drawing

Insert Drawing Textbox on Graph Chart in Google Sheets

 

3. Click on the Textbox tool

4. Drag to create a textbox on the checkered background

Create Textbox Drawing on Graph in Google Sheets

 

5. Type and Format the textbox that you would like to create. Click Save and Close

Finalize Textbox to Format Graph in Google Sheets

Final Graph with Textbox

Final Graph with Textbox in Google Sheets