Get more control over chart data labels in Google Sheets

We’re adding new features to help the charts you create in Google Sheets better represent the data they contain. These features include showing total data labels for stacked charts and controlling where data labels are placed.

Show totals in stacked charts
You can now add total data labels in stacked charts, which show the sum of all content in a data set.

Choose the alignment of your data labels
You can also choose where data labels will go on charts. The options you have vary based on what type of chart you’re using.

For column and bar charts, the data label placement options are:

  • Auto - Sheets will try to pick the best location
  • Center - In the middle of the column
  • Inside end - At the end of the column
  • Inside base - At the base of the column
  • Outside end - Past the end of the column

For line, point, and area charts, the placement options are:

  • Auto - Sheets will try to pick the best location
  • Center - over the middle of the plot point
  • Left - to the left of the plot point
  • Right - to the right of the plot point
  • Above - above the plot point
  • Below - below the plot point

Launch Details
Release track:
Launching to Rapid Release, with Scheduled Release coming in two weeks

Available to all G Suite editions

Rollout pace:
Gradual rollout (up to 15 days for feature visibility)

All end users

Change management suggested/FYI

More Information
Help Center: Edit a chart in Sheets

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates