Slide thumbnail

Update knowledge G Suite

Knowledge

Get more control over chart data labels in Google Sheets

10/05/2018

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.

 

Google sheets data label

 

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 usi

 

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

 

Google sheets data label

 

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

 

Google sheets data label

 

Updated: Gimasys

Knowledge

Update and support center for administrator and user