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
- 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.