While working with Microsoft Excel, sometimes we need to add some extra notes to a chart. We can easily add notes in Excel charts. Adding notes to a chart is an easy task. This is a time-saving task also. Today, in this article, we’ll learn two quick and suitable ways to add notes in an Excel chart effectively with appropriate illustrations.
How to Add Notes in Excel Chart: 2 Quick Ways
Let’s say, we have a dataset that contains information about several Students of XYZ school. The Name of the students and their securing marks in Electrical and Electronics Engineering(EEE) and Computer Science Engineering(CSE) are given in columns B, C, and D respectively. We will create a 2D Column chart, and make a Pie chart to add notes in Excel. Here’s an overview of the dataset for our today’s task.
1. Create a Column Chart to Add Notes in Excel
To add notes to the Excel chart, we will create a chart. Undoubtedly, adding notes to a column chart is an easy task. This is a time-saving task also. Let’s follow the instructions below to add notes to a chart!
Step 1:
- First of all, we will create a chart to add notes. To do that, firstly select the table range B4 to D10. Secondly, from your Insert tab, go to,
Insert → Charts → 2-D Column
- After that, you will be able to create a 2-D Column.
Step 2:
- After creating a chart, we will add notes to that chart. To do that, from your Format ribbon, go to,
Format → Insert Shapes → Text Box
- As a result, a Text Box will appear in front of you. Hence, we will be able to add notes to the Text Box. “Notes: 2D Column Chart to Compare the Marks Between EEE and CSE” is our notes that have been added in the Text Box.
Read More: How to Add Notes in Excel Formula
2. Make a Pie Chart to Add Notes in Excel
In this portion, we will learn how to add notes to a pie chart. From our dataset, firstly, we will make a pie chart. Then we will add notes to that pie chart. Let’s follow the instructions below to add notes to a chart!
Step 1:
- First, we will create a pie chart to add notes. To do that, firstly select the table range B4 to D10. Secondly, from your Insert tab, go to,
Insert → Charts → 2-D Pie
- After that, you will be able to create a 2-D Pie chart which is given in the below screenshot.
- Now, we will apply the Chart Design ribbon to show the percentage in the pie chart. To do that, from your Chart Design ribbon, go to,
Chart Design → Chart Styles
Step 2:
- After creating a chart, we will add notes to that chart. To do that, from your Format ribbon, go to,
Format → Insert Shapes → Text Box
- As a result, a Text Box will appear in front of you. Hence, we will be able to add notes to the text box. “Notes: To Understand the Student’s Marks in EEE, We Create a Pie Chart.” is our notes that have been added in the text box.
Things to Remember
➜ While a value can not found in the referenced cell, the #N/A error happens in Excel.
➜ To create a chart, firstly, select the data range. After that, from your Insert tab, go to,
Insert → Charts
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
I hope all of the suitable methods mentioned above to add notes in chart will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.