Add data labels, notes or error bars to a 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 on the chart that you want to change.
3.  On the right, click Customise  Series.
4. Optional: Next to 'Apply to', choose the data series that you want to add a label to.
5. Click Total data labels.
6. Optional: Make changes to the label font.

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 the week	Sales	Notes
2	Monday	50	Low profits
3	Tuesday	100	Online voucher announced

Step 2: Add labels

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

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 the week	Notes	Sales
2	Monday	Low profits	50
3	Tuesday	Online voucher announced	100

.

Step 2: Add labels

1. Double-click on the chart that you want to add notes to.
2. At the right, click Setup.
3. In the box next to 'Series', click More Add labels.
4. Enter the data range with your notes. For example, B2:B3.