Add data labels
You can add data labels to a bar, column, scatter, area, line, waterfall, histograms, or pie chart. Learn more about chart types.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize
Series.
- Check the box next to “Data labels.”
Series.Tip: Under "Position," you can choose if you want the data label to be inside or outside the bar.
Edit data labels
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize
- To customize your data labels, you can change the font, style, color and number format.
Tip: To edit an individual data label, double-click the text.
If you’re creating a pie chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Click Pie chart.
- Under "Slice label," choose an option.
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 labels.Add error bars to a chart
You can add error bars to bar or line charts based on a constant value, a percentage value of a specific item, or the series' standard deviation value. If you choose the standard deviation type, the error bars are centered on the mean of the series, not on the value of each individual item.
- On your computer, open a spreadsheet in Google Sheets.
- To open the editor panel, double-click the chart.
- Click Customize
Series.
- Check the box next to “Error bars.”
- Choose the type and value.