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

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.

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


Similar Readings


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

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

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.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo