How to Add a Caption to a Graph on Excel

Save

Adding a caption to a graph in Microsoft Office's Excel spreadsheet program helps explain the context of or any notable conclusions to be drawn from the data being represented. The program does not include any built-in captioning options, but you still have the ability to create one that lines up with a graph in your document. Utilize a combination of text box and grouping options to add a caption beneath your graph in Excel.

  • Open the Microsoft Excel document that contains your graph. Click the Insert menu on the ribbon at the top of the window.

  • Click the "Text Box" option from the Text area on the ribbon.

  • Click anywhere on the spreadsheet and drag your cursor to the caption's desired width and length. Release your mouse button to finish sizing the text box.

  • Type your desired caption into the text box you just created.

  • Move your cursor to the outer edge of the text box until your cursor changes to a cross symbol. Click and drag the text box, positioning it beneath your graph.

  • Click and drag the white squares on the left or right side of the text box to resize it to fit the width of the graph.

  • Hold down the "Ctrl" key on your keyboard and then click the graph and the text box with your mouse. Holding down the "Ctrl" key allows you to select both items at the same time.

  • Right-click either item and hold your cursor over the "Group" option. Grouping options appear to the right of your cursor.

  • Click "Group" in the list of options to the far right. The text box and the caption become locked together, allowing you to resize and reposition them as one unit, if desired.

References

  • Photo Credit Jupiterimages/Comstock/Getty Images
Promoted By Zergnet

Comments

Resources

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!