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

Settings for each chart type

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

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)

X axis annotation example

Y axis annotation example