Skip to content

Chart Options

The Chart Options panel contains settings to change the chart’s axis sorting, axis minimums & maximums and other chart specific settings.

Using the Chart Options panel to create a normalized, horizontal bar chart
Using the Chart Options panel to create a normalized, horizontal bar chart

Options for Specific Chart Types

This section allows you to set options that only apply to one or more chart types.

  • Normalize

Normalize will change the scale of the y-axis to a percentage of 100. It will look as though the plotted bars stretch to the top of the chart.

Bar Charts

  • Horizontal Bars Enable this toggle to show the bars of a Bar chart horizontally instead of vertically. This is useful when there is categorical info plotted on the x-axis that have long names. The long names are more easily read horizontally rather than vertically.

  • Waterfall Bars Applies to bar charts only. Enable this toggle to make bars appear as a cumulative value, appearing like a waterfall. Use the Colors panel on the Size & Style value to set the colors for regular bars and negative value bars.

An example of a waterfall chart used to show cumulative earnings over the course of a year.
An example of a waterfall chart used to show cumulative earnings over the course of a year.
  • Bar Border Radius Round the corners of each bar.
  • Custom Bar Width Toggle on to set an exact bar width instead of letting bars size automatically.

Line Charts

  • Show Markers Toggle on to show a dot at each data point along the line.
  • Smooth Lines Toggle on to curve the line between points instead of drawing straight segments.
  • Line Width Set the thickness of the line.

Area Charts

  • Stack / Normalize / No Stack Choose whether area series stack on top of each other, stack and normalize to a percentage of 100, or don’t stack at all.
  • Show Markers, Smooth Lines, Fill Opacity, and Line Width work the same as on Line charts, with Fill Opacity controlling how see-through the filled area is.

Pie Charts

  • Semi Circle Toggle this setting on to only show the chart as a half circle instead of a full circle pie chart.

  • Donut Inner Size Set the percentage of the inner cut out size of the pie chart - resembles a donut.

  • Border Radius Round the corners of each pie slice.

A pie chart with both the semi circle setting enabled and an inner donut size set.
A pie chart with both the semi circle setting enabled and an inner donut size set.

Radar Charts

  • Show Markers and Line Width work the same as on Line charts.

Heatmap

  • Fill in missing values Normally empty or 0 values will be shown as an empty void in the chart. Enable this setting to fill in blank values with a colored box.

  • Border Radius Round the corners of each cell.

Sorting

Auto Sort is enabled by default to automatically sort the items in the chart.

Turn off auto sort to manually control how the chart is sorted.

  • Sort X-Axis Which axis to sort the X-Axis by. Options include: Auto, X-Axis and Y-Axis/Series

  • Sort Direction The direction to sort the X-Axis in. 0 for auto, 1 for Ascending and 2 for Descending

  • Sort Legend Which axis to sort the legend by. Options include: Auto, X-Axis and Y-Axis/Series

  • Legend Sort Direction The direction to sort the legend in. 0 for auto, 1 for Ascending and 2 for Descending

Numeric Axis Min and Max

Use these settings to control the min and max values plotted on each axis. Toggle off Use Default Values first to enter your own numbers.

  • X-Axis Min & Max Set these 2 values to control the smallest and largest value plotted on the X-Axis. This option will be disabled if the chosen X-Axis column is not numeric.

  • Y-Axis Min & Max Set these 2 values to control the smallest and largest value plotted on the Y-Axis. This option will be disabled if the chosen chart type is a Heatmap.

  • Breakdown Min & Max Set these 2 values to control the smallest and largest value plotted on the Breakdown Axis (if there is a Breakdown set).