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 Insert & Add a Text Watermark on Google Docs Documents

Creating original content will require a huge amount of time, effort, and brainpower. Not all work outputs come easy. Sometimes, creators need to spend...

How to Reset App Volume and Device Preferences in Windows 10

Windows 10 supports playback of multiple audio streams based on individual applications. This means that if you have speakers and headphones, you can choose...

How to Get Refund & Cancel your AppleCare or AppleCare Plus Plan

Buying an Apple device is like an investment. You have to pay a higher price to own one, but it comes with a long-term...

How to Open and Read EPUB eBook Files on Windows 10 PC

Reading e-books will give you access to thousands of books that you may have difficulty finding or acquiring with physical books. You can carry...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected