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 chartsYou 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 labelsYou 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 DetailsRelease track:Launching to Rapid Release, with Scheduled Release coming in two weeks
Editions:
Available to all G Suite editions
Rollout pace:Gradual rollout (up to 15 days for feature visibility)
Impact:
All end users
Action:
Change management suggested/FYI
More InformationHelp Center: Edit a chart in SheetsLaunch release calendarLaunch detail categoriesGet these product update alerts by emailSubscribe to the RSS feed of these updates