Md. Abdur Rahim Rasel
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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
2 Quick Ways to Add Notes in Excel Chart
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.
Similar Readings
- How to Print Notes in Excel (2 Simple Methods)
- Convert Comments to Notes in Excel (3 Suitable Ways)
- How to Hide Notes in Excel (3 Handy Approaches)
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 has been 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.
Read More: How to Add Notes in Excel Formula (4 Effective Ways)
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
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.
