Add a text box to a chart

To add text to a chart that is separate from the text in chart titles or labels, you can insert a text box on the chart. You can then enter the text that you want.

Tip: Instead of entering text in the text box, you can link the text box to data in a worksheet cell. When the text box is linked to a worksheet cell, any changes that you make to the data in that cell will appear automatically in the text box on the chart.

After you create a text box in a chart, you can move, resize, or remove it as needed.

Insert a text box on a chart

  1. Click the chart to which you want to add a text box.

    This displays the Chart Tools, adding the Design and Format tabs.

  2. On the Format tab, in the Insert Shapes group, click the Text Box icon Button image .

  3. In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.

  4. In the text box, type the text that you want.

    The text will wrap in the text box. To start a new line in the text box, press Enter.

  5. When you finish typing, press Esc to cancel editing mode, or click anywhere outside of the text box.

Insert a text box on a chart

  1. Click the chart to which you want to add a text box.

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  2. On the Layout tab, in the Insert group, click Text Box Button image .

    Excel Ribbon Image

  3. In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.

  4. In the text box, type the text that you want.

    The text will wrap in the text box. To start a new line in the text box, press Enter.

  5. When you finish typing, press Esc to cancel editing mode, or click anywhere outside of the text box.

Move or resize a text box

  1. On the chart, click the text box that you want to move or resize.

  2. Do one of the following:

    • To move the text box, position the cursor on the border of the text box so that it changes to a four-headed arrow, and then drag the text box to the location that you want.

    • To resize the text box, click any sizing handle, and then drag until the text box is the size that you want.

      Tip: For precise sizing measurements, on the Format tab, in the Size group, type the size that you want in the Shape Height and Shape Width boxes.

    • To rotate the text box, click the rotation handle, and then drag the text box to the degree of rotation that you want.

      Tip: For precise rotation, on the Format tab, in the Arrange group, click Rotate, and then click the rotation option that you want.

Remove a text box

On the chart, click the border of the text box that you want to delete, and then press DELETE.

See also

Add, copy, or delete a text box

Link a chart title, label, or text box to a worksheet cell

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×