You can set the max and min values for chart axes in non-proportion bar charts and non-percentage line charts.
How to set max and min value for your chart axis?
You can set the max and min values for chart axes in non-proportion bar charts and non-percentage line charts.
These settings, labeled "Max Axis Value" and "Min Axis Value," are located in the Custom tab under the "Build your chart" step when building or editing your Insights. You can set these values by entering numbers into the input boxes or using the stepper.
-
The Max Axis Value must be greater than or equal to the largest data point in the chart.
-
The Min Axis Value must be smaller than or equal to the smallest data point in the chart.
Note:
-
To enable the "Min Axis Value" setting, you must set the "Max Axis Value" first.
How to set increments for axis?
If both "Min Axis Value" and "Max Axis Value" are set, you can also set axis increments for bar charts and line charts. This option is located below the Max/Min Axis Value settings. You can set increments by typing numbers into the input boxes or using the stepper.
Min value for axis increments:
To ensure axis tick readability, the max number of axis ticks is set to 20. Based on this:
-
For proportion/percentage charts, the minimum value must be greater than or equal to 0.05.
-
For non-proportion/percentage charts, the min value must be greater than or equal to
(MaxAxisValue - MinAxisValue) / 20
Max value for axis increments:
-
For proportion/percentage charts, the max value must be less than 1
-
For non-proportion/percentage charts, the max value must be less than
MaxAxisValue - MinAxisValue
Note:
-
For non-proportion bar charts and non-percentage line charts, both "Min Axis Value" and "Max Axis Value" must be set first to enable this feature.
-
If some axis ticks are too close, they may not be displayed.