How to Add a Comment on a Graph in Excel (3 Easy Methods)

We will consider a dataset of Sales of ABC Traders from B4 to C10. We will add a chart and add a comment on it.

dataset of how to add a comment on a graph in excel


Method 1 – Adding a Comment on a Graph in Excel by Using a Text Box

We will use a text box to add a comment on an Excel graph.

Adding a Comment on a Graph in Excel by Using a Text Box

Steps:

  • Add a chart.

Adding a Comment on a Graph in Excel by Using a Text Box

  • Select the chart.
  • Go to the Format tab.
  • Select the Text Box option in Insert Shapes.

Adding a Comment on a Graph in Excel by Using a Text Box

  • Add the text box inside the chart below the line.

Adding a Comment on a Graph in Excel by Using a Text Box

  • Add a note or comment in the text box.

Adding a Comment on a Graph in Excel by Using a Text Box


Method 2 – Inserting a Comment on a Graph in Excel from a Data Label

Steps:

  • To label one particular data point, click the data series and click that target data point after clicking the series.
  • Right-click on the highlighted data point.
  • Select the Add Data Label option from the context menu.

Adding a Comment on a Graph in Excel from Data Label

  • You will find a data label beside the data point.
  • Right-click on the data label.
  • Click on Change Data Label Shapes.
  • Select a data label shape option.

Adding a Comment on a Graph in Excel from Data Label

  • You will get a comment box like the picture given below.

Adding a Comment on a Graph in Excel from Data Label


Method 3 – Add a Comment on a Graph in Excel Using the Insert Tab

Steps:

  • Go to the Insert tab in your Excel 365.
  • Select the Add Text button.

Add a Comment on a Graph in Excel Using Insert Tab

  • Add the text box to the graph.

Add a Comment on a Graph in Excel Using Insert Tab

  • Write down the comment in the textbox.

Add a Comment on a Graph in Excel Using Insert Tab


How to Add Comments to an Excel Worksheet

Steps:

  • Select the C5 cell.

  • Go to the Review tab.
  • Select Edit Comment or Add Comment
  • A comment box is opened.

  • You can write any comments in the dialog box.

  • You will find the added comments in a cell just like the picture given below.
  • You can read or edit the comment by clicking on the small arrow on the top-right of the cell.


How to Add Comments in Excel Worksheet with a Keyboard Shortcut

Steps:

  • Select the C5 cell.

  • Press Shift + F2.
  • A comment box will open in the cell like in the picture below. You can write any comments in that dialog box.

  • The selected area will help you to edit the comments by clicking on it.


Download the Practice Workbook


Related Article


<< Go Back to How to Add a Comment in Excel | Comments in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

3 Comments
  1. This is very helpful for my work.

  2. To place a Data label on a data point, must click data point 2x, 1st click selects the series, 2nd click selects the point

    • Thank you so much for the useful note, ASD. We have included it in the article for our users to understand that step better. Much appreciation from ExcelDemy. Keep sharing your experience with us.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo