How to Include Captions in Excel Graphs

By Kathryn Hatashita-Lee

Insert a text box to contain your captions in the chart area.
i Photodisc/Photodisc/Getty Images

Microsoft Excel 2010 lets you type captions on your chart in order to make the data more meaningful to your colleagues and clients. Insert a text box right inside a chart area to contain and position your text in the layout. Customize the text with the editing commands, such as font, text effects or color, so your captions stand out and complement your data.

Click the “Insert” tab on the command ribbon and then click “Text Box” in the Text group. The cursor will convert to a vertical and horizontal line symbol as you mouse over the chart area.

Click and drag in your chart area to create a text box. The Drawing Tools ribbon with the Format tab will display.

Type your caption in the text box. To edit the font, click the “Home” tab on the ribbon and click an option, such as “Bold” or “Font Color.”

Resize the text box by clicking inside to bring up the sizing handles. Click and drag a handle to change the dimensions to fit your chart layout.

Click outside the text box to set it in the chart. If you move the chart on the worksheet, your caption will move with it.

Save this worksheet.