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.