HomeHow ToHow to Include Captions in Microsoft Excel Graphs and Charts

How to Include Captions in Microsoft Excel Graphs and Charts



It is easy and effective to create graphs and charts using Microsoft Excel. You can organize your data and information in an Excel document with different layouts and tools available for you. But, have you encountered a graph or chart where you cannot identify what the numbers are all about?

Not all charts are easy to read and understand, especially when you only see the data without any added explanation. That is why adding a caption can help you integrate additional information to further explain every data that appears on your charts and graphs in Microsoft Excel.

Luckily, you can add a caption to your graphs by using text boxes.

When creating your charts or graphs, make sure to add an extra space to place your text boxes for captions. Position these captions next to the data where it offers an additional explanation.

How to Add Captions in Microsoft Excel Graphs and Charts

Image / Microsoft
  • Open your spreadsheet on Microsoft Excel.
  • Along the menu bar, click Insert.
  • Select Text Box.
  • Adjust the Text Box to where you want it to be.
  • Type the information that you want to add to your caption.
  • Now, you can adjust the formatting of your text. You can edit the font, the font size, and font color of your caption. You can also set it to Bold or Italic. You can also adjust the size of your text box.
  • Once you are done with your caption, click outside the text box to set it in place.
  • Click Save.

Creating a Caption Text Using Excel Formula

If you already have a text that you want to integrate as a caption in your excel and graph, you can use the formula where the text is located and copy it to your caption. The advantage of using formula cells to your caption is the automatic change in your caption when data in the cell changes.

  • To add a formula to your caption, go to your text box.
  • Click the formula bar.
  • Add the = sign and select the cell containing the information you want to for your caption. Click Enter.

MS Excel offers an efficient way to professionally arrange your graphs and charts needed for work, business, and even school presentations. How do you like making graphs and charts on Microsoft Excel? Share your thoughts with us in the comments below.


More From

How to Update Firmware or Device Software on Vizio Sound Bar Manually

We have discussed how crucial it is to update the firmware on your Vizio soundbar. You can enjoy the maximum benefits that your sound...

Use Google Duo for Video Conferencing and Ditch Zoom

Did you know that you can now use Google Duo for videoconferencing? That's right! Despite the name Duo, which means two, Google's video calling...

How to Fix Authy Verification Code Not Work­ing

Using two-factor authentication (2FA) codes gives us peace of mind when it comes to our online logins and passwords. 2FA codes add another layer...

How to Check & Tell if your Android Phone Supports Google’s RCS Messaging

Google launched the RCS chat messaging service to make text messaging more engaging and lively on Android smartphones. RCS or Rich Communication Service augments...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected