Column formatting in table charts

Column formatting

Apply specific formatting styles to table columns, such as date formatting or text color.

Open your chart for editing, and click the Chart 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.

Formatting dates

Each date bucket (month, week, day, etc.) offers different formatting options.

Example

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.

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.

If a column value fits more than one formatting rule, Chartio will use whichever formatting rule is later in the list.