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 Gear above the Chart Preview.
- In Data Explorer, click Settings next to the chart title.
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.
- Default (e.g.,
- For numeric labels, choose from the following:
- 1K
- $1,000.00
- 1,000.00
- 1000.00
- 1 000,00
- 1000,00
- For datetime labels, choose from the following:
-
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
-
Use the color picker to set the color of each column represented on your chart. You could also input the hexadecimal color code if you’d prefer. Make sure to click Select once you’ve chosen your color to update the selection.
-
The colors are tied to each specific result set in your chart, so if the ordering in your chart changes due to the data changing, the color you associated with Login, for example, always stays associated with Login. However, the color resets if you change the name of Login.
-
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)