New chart text and number formatting options in Sheets

Quick launch summary 

We’re adding new features to help you customize chart text and numbers in Google Sheets. Specifically, you can now: 
  • Directly click on almost any chart text element and update both its content and style, most notably individual data labels and legend items. 
  • Set advanced number formatting options on both your data labels and axis labels, including the option to conditionally format by color. 
  • Use a contextual sidebar editing experience, making it easier to format individual data labels, legend items, and single data points. 
See images below for demonstrations: 

Customize the text content and style of legend items and single data labels 

Advanced number formatting of chart data and axes labels (including conditional color formatting) 

Quickly format single data columns, bars, or points using the contextual sidebar 


Getting started 

Rollout pace 

Availability 

  • Available to all G Suite customers and users with personal accounts 

Resources