# 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

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

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

- **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/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.

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

- **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).