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 and area stretch to the top of the chart.

  • 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.
  • Semi Circle For Pie charts only. Toggle this setting on to only show the chart as a half circle instead of a full circle pie chart.

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

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.
  • Fill in missing values For Heatmaps only. 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.

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

  • 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

  • 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.

  • 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 Stacked Bar chart.

  • Group Axis Min & Max Set these 2 values to control the smallest and largest value plotted on the Group Axis (if there is a group axis for the chosen chart type).