Documentation Charts

Chart Settings

Each chart type has its own customizable chart settings. The settings are grouped into different tabs, but not all chart types have every settings tab.

You can get to the Chart Settings via one of the following methods:

  • From the dashboard, open the chart’s ellipsis menu and click Edit Settings
  • In Visual SQL, click the Paintbrush above the Chart Preview pane.
  • In Data Explorer, click Settings next to the chart title.

Chart Settings for Bar Line chart

Chart settings tabs

General Axis Color Columns
Conditions Series Drilldown Annotation

Settings for each chart type

Area Bar Bar Line Box Plot
Bubble Map Bubble Bullet Funnel
Heat Map Line Map Pie
Scatter Plot Single Value Single Value Indicator Sparkline
Table

General

Applicable chart types: All

Listed below are some common fields found in almost every chart type’s General settings tab. Fields for a specific chart type can be found on the chart type’s settings page.

Chart title
The title of your chart
Title font size
The font size of your chart title; minimum value is 8
Show legend
By default, all charts display a legend if there are multiple groupings in your chart. You can change this via the Show legend dropdown in the General tab of the settings. The following options are available:
  • Always: the legend always appears on the chart
  • Never: the legend is hidden from the chart
  • Auto: the legend appears when multiple groupings are present
Show tooltips
Enable tooltips, which appear when you hover over areas of your chart and show the values at the specified point
Round tooltip values
Available when Show tooltips is selected

Rounds real numbers in the tooltip to two decimal places

Deselect to show the raw values in the tooltip


Axis

Applicable chart types: All except Bubble Map, Map, Pie, Single Value, Single Value Indicator, and Table

Listed below are some common fields found in almost every chart type’s General settings tab. Fields for a specific chart type can be found on the chart type’s settings page.

X Axis

Title
Title for the x-axis
Show labels
When selected, shows the label at each step in your x-axis (depends on specified Label steps)
Label steps
Available when Show labels is selected
  • Auto: Applies labels to certain steps
  • Show all labels: Applies labels to every step If the label is too long, it appears as an ellipsis (…) but the full label is visible in the tooltip (see Show tooltips in the General tab)
Rotate labels
Rotate the x-axis labels by -45, -30, 30, or 45 degrees—or don’t rotate them at all

Another way to work with long label names is to use angled or rotated labels. This is great for situations when you can’t (or don’t want to) swap the axes of your chart, or when you have long labels on both axes. If you select Label steps > Show all labels, you can avoid the ellipsis labels by rotating them. Angled labels will get harder to read the more they are rotated, so only angle them as much as is needed.

Label format
Depends on the data type of the x-axis
  • For datetime labels, choose from the following:
    • Default (e.g., Jan 1, 2020)
    • ISO-8601 (e.g., 2020-01-31)

    Check out our FAQ about X-axis date labels if you’re having issues.

  • For numeric labels, choose from the following:
    • 1K
    • $1,000.00
    • 1,000.00
    • 1000.00
    • 1 000,00
    • 1000,00

Note: If your chart values are integers, labels will be integers too.

Y Axis

Title
Title for the y-axis
Show labels
When selected, shows the label at each step in your y-axis (depends on specified Label steps)
Rotate labels
Rotate the y-axis labels by -45, -30, 30, or 45 degrees—or don’t rotate them at all
Label format
Depends on the data type of the y-axis (see Label format from the X Axis section for more details)
Range override
Select whether or not to use the y-axis range chosen by Chartio
Min
Available when Range override is selected

Specify the minimum value of your y-axis

Max
Available when Range override is selected

Specify the maximum value of your y-axis

Steps
Available when Range override is selected

Specify the number of steps to show between your Min and Max values


Color

Applicable chart types: All

Listed below are some common fields found in almost every chart type’s General settings tab. Fields for a specific chart type can be found on the chart type’s settings page.

Background color
The background color of your chart

By default, uses the background color of the Dashboard Theme; selecting another color overrides background color of the dashboard theme

Use custom colors
Select to override the colors of the dashboard theme

Columns

Applicable chart types: Table


Conditions

Applicable chart types: Single Value and Table


Series

Applicable chart types: Area, Bar, Bar Line, Bubble, Bubble Map, Heat Map, Line, Scatter Plot, and Sparkline


Drilldown

Applicable chart types: All except Sparkline

Turn your chart into a Drilldown by selecting the dashboard and Dashboard Controls to connect it to.


Annotation

Applicable chart types: All except Bubble Map, Funnel, Map, Pie, Single Value, Single Value Indicator, and Table

Add a note at a specific x or y-axis value in your chart to provide your teammates with some context for the data or add a target line to your chart.

Show annotation labels on chart
Select to show the Label you provide when adding a new annotation

Add a new annotation

Click Add new annotation to create a new annotation.

Axis
Choose to add an annotation at a value on the X Axis or the Y Axis
Value
Specify the value on the chosen axis to show the annotation; the sample values below the form field show the required format
Label
The note you’d like to add; appears next to the annotation line
Color
Choose the color of the annotation (for both the line and text)

X axis annotation example

Axis notes

Y axis annotation example

Y-axis annotations