Apply specific formatting styles to Table chart columns, such as date formatting or text color.
Open your chart for editing, and click the Settings button. In the Chart Settings, switch to the Columns tab. Set defaults under the Default Column Formatting section, or click Add New Formatting Rule to format an individual column.
To format a numeric column as currency, for example, add a new formatting rule and select Currency from the Number dropdown.
Each date bucket (month, week, day, etc.) offers different formatting options.
Our chart is grouped by week number, and we want to instead show the date range for the week. In our Chart Settings, we’ll switch to the Columns tab, click + Add New Formatting Rule, and select our week column from the Format Column dropdown. Then we’ll select Long from the Week Formatting dropdown, and click Done and save the chart.
Conditional column formatting
Apply formatting to column values when they meet a specific condition. You may apply as many conditional rules to a chart as you wish.
Open your chart for editing, and click the Chart Settings button. In the Chart Settings, switch to the Conditions tab. Click Add New Conditional Rule.
In our example, we want to highlight any rows where the count of new users is greater than 150. We’ll select our column, set our condition, and adjust our Text Styles.
Format multiple columns
You may apply conditions to multiple columns, as long as the columns are the same data type. Simply select additional columns from the Format Column dropdowns.
To format all columns of the same data type, choose “All numeric columns” or “All text columns” from the Format Column dropdown.
Note: later rules can override earlier rules. If a column value fits multiple rules, the later rule will be applied.
Check out a video below to see an example of doing this: