Add data labels or notes to a chart

Add & edit data labels

Before you edit: You can add data labels to a bar, column, scatter, area, line, waterfall, histograms, or pie chart. Learn more about chart types.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Series.
  5. Optional: Next to "Apply to," choose the data series you want to add a label to.
  6. Click Data labels.
  7. Optional: Under "Position," choose where you want the data labels to show.
  8. Optional: Make changes to the label font.

If you’re creating a pie chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Pie chart.
  5. Under "Slice label," choose an option.
Add a total data label to a stacked chart

You can add a label that shows the sum of the stacked data in a bar, column, or area chart. Learn more about types of charts.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Series.
  5. Optional: Next to "Apply to," choose the data series you want to add a label to.
  6. Click Total data labels.
  7. Optional: Make changes to the label font.

Add notes to a chart

You can add a note, or annotation, to explain trends in the data.

Before you add a note: You can add notes to bar, column, scatter, area, line, and waterfall charts. Learn more about chart types.

Add notes to a data point

Step 1: Add text notes

  1. On your computer, open a spreadsheet in Google Sheets.
  2. In the column to the right of each data point, add your text notes.

If your notes don’t show up on the chart, go to step 2.

Example

  • Column A: Labels for horizontal axis
  • Column B: Data points for vertical axis
  • Column C: Notes
  A B C
1 Day of Week Sales Notes
2 Monday 50 Low profits
3 Tuesday 100 Online coupon announced

Step 2: Add labels

  1. Double-click the chart you want to add notes to.
  2. At the right, click Setup.
  3. In the box next to "X-axis," click More More and then Add labels.
  4. Enter the data range with your notes. For example, C2:C3.
  5. Click OK.
Add notes to the horizontal axis

Step 1: Add text notes

  1. On your computer, open a spreadsheet in Google Sheets.
  2. To the right of the column with your X-axis, add your notes.

If your notes don’t show up on the chart, go to step 2.

Example

  • Column A: Labels for horizontal (X) axis
  • Column B: Notes
  • Column C: Data points for each label
  A B C
1 Day of week Notes Sales
2 Monday Low profits 50
3 Tuesday Online coupon announced 100

.

Step 2: Add labels

  1. Double-click the chart you want to add notes to.
  2. At the right, click Setup.
  3. In the box next to "Series," click More More and then Add labels.
  4. Enter the data range with your notes. For example, B2:B3.
Was this article helpful?
How can we improve it?