This post will guide you how to add a comment to a data point in an excel chart. How do I add a comment into a data point of chart or graph in excel.
1. Adding comment to A Data Point in a Chart
For example, if you have created a line chart in your current worksheet like as below:
![add comments1](https://www.excelhow.net/wp-content/uploads/2018/05/add-comments1.jpg)
Then you want to add one comment for a data point in the line chart. Just do the following steps:
#1 right click on a certain data point, click Add Data Labels from the drop down list. Then select Add Data Labels.
![add comments2](https://www.excelhow.net/wp-content/uploads/2018/05/add-comments2.jpg)
#2 right click on the data label, select Format Data Label… from the pop-up menu list.
![add comments3](https://www.excelhow.net/wp-content/uploads/2018/05/add-comments3.jpg)
#3 add comment “excelhow” in the data label
![add comments4](https://www.excelhow.net/wp-content/uploads/2018/05/add-comments4.jpg)
#4 right click on the data label again, select Change Data Label Shape, then select one data label shapes, such as: Right Arrow Callout.
![add comments5](https://www.excelhow.net/wp-content/uploads/2018/05/add-comments5.jpg)
#5 you will see that a comment has been added into the data label of data point in this line chart.
![add comments6](https://www.excelhow.net/wp-content/uploads/2018/05/add-comments6.jpg)
You can format the data label to customize its appearance and location on the chart.
Leave a Reply
You must be logged in to post a comment.