How to Add Notes in Excel Chart (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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 names 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 today’s task.

add notes in excel chart


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

Create a Column Chart to Add Notes in Excel

  • 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

Create a Column Chart to Add Notes in Excel

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

Create a Column Chart to Add Notes in Excel


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

Make a Pie Chart to Add Notes in Excel

  • 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

Make a Pie Chart to Add Notes in Excel

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.

Make a Pie Chart to Add Notes in Excel


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


Related Article


<< Go Back to How to Add Notes in Excel | Notes in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo