Set Axis min to (auto) to display negative and mixed values in charts.
As of 2019-01-16, the default value for Axis min is (auto), so you'll only need to change this for older charts.
Previously, the default Axis min setting was "0."
To display metrics with negative values in a chart, set the Axis min option to (auto):
- Edit your report.
- Select the chart.
- Select the STYLE panel.
- Locate the main axis settings: for default charts, this will be the left axis, but could also be right or bottom, depending on how you've customized your chart.
- Change the Axis min value to (auto) by deleting the current setting.
Here's an example of how charts look with Axis min 0 versus Axis min (auto):
- Data in the top charts contains mixed negative and positive values.
- Charts on the left are set to use Axis min: 0.
- Charts on the right use Axis min: (auto).
- Note how the last two dimension values ("Green" and "Blue") appear in the charts.
- Data in the middle charts only contains positive values. In this case, there is no difference between 0 and (auto) settings.
- Data in the bottom charts only contains negative values. Here, using the (auto) setting on the right provides the correct visualization.