Table charts can be customized in a number of ways depending on the type of data included. Below are some ways you can your Table chart’s formatting.
Apply specific formatting styles to Table chart columns, such as date formatting or text color.
To edit your Table’s formatting, open the Chart Settings by clicking Edit Settings from the chart ellipsis menu on your dashboard. You can also access this window by selecting Edit Chart Data from the menu and clicking the Settings button above the chart preview.
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. Click Done to save any changes.
Each date bucket (month, week, day, etc.) offers different formatting options. You can take a look at the different options in our Date formatting options in the settings article.
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. We’ll then select Long (start day - end day) from the Week Formatting dropdown, and click Done and save the chart.
By default, columns in Table charts are auto-sized depending on the row length. However, should you wish to customize column sizing, you can do so in the chart’s settings.
Open your Chart Settings and click +Add New Formatting Rule. Select the column to edit then select Percent from the Column Width dropdown and set your desired percentage. Other columns’ size will auto-adjust accordingly. Any text-overflow in your column will be truncated with an ellipsis, and the full text is viewable on hover or by clicking the View all columns and rows link at the bottom of the Table.
Tip: If you need a column in your chart for formatting or other reason but you don’t want it displayed in the table on your dashboard, you can “hide” the column by setting its percentage to 0. Note that the column’s results will still be available in the extended table view and in Table downloads.
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 the example below, we want to highlight any results where the count of new users is greater than 150. To do this, we’ll select our Count of Users column, set our condition to “Is greater than 150”, and adjust our Text Style options and Background Color as needed. Then, click Done to save the changes.
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 the video below to see an example of setting up conditional formatting: