Setting the Bar Axis Maximum

Use Axis Maximum to set the value that fills the full width of a bar, so the bars of different charts use the same scale.

By default, each bar chart scales to its own longest bar. A bar of 975 in one chart can be longer than a bar of 3,554 in another chart. When you set the same Axis Maximum in each chart, the length of a bar shows its value in every chart.

Permissions: To add a chart, you need the Dashboards > Charts > Add permission. To edit a chart, you need the Dashboards > Charts > Edit permission. You don't need these permissions on your own private dashboard.

Axis Maximum is available in the Bar view of these charts:

• Query Comparison
• Field Segmentation
• Pivot Chart
• Query Intersection
• Adapter Segmentation (the only view of this chart is a bar chart)

To set the axis maximum:

1. Open a dashboard.
2. Open the menu of a bar chart, and click Edit.
3. Go to the presentation settings.
4. Enable Axis Maximum.
5. In the number field, enter the maximum value, for example 5000.
6. Click Save.
7. Repeat steps 2 to 6 for each chart that must use the same scale. Enter the same maximum in each chart.

• By default, this option is disabled, and the longest bar of the chart fills the full width.
• When this option is enabled, the number you enter is the full width of a bar. The length of each bar is its value divided by this maximum.
• The minimum value is 1.
• A bar with a value larger than the maximum fills the full width.
• When the option is enabled and the number field is empty, the chart scales to its longest bar, the same as when the option is disabled.
• The option changes only how the bars look. It doesn't change the chart data or the totals.
• When you disable the option and enable it again, the last number comes back.
• Charts that you saved before the upgrade don't change.

Example: A dashboard has three Field Segmentation bar charts, one for each region. Without the option, a bar of 975 in one chart can be longer than a bar of 3,554 in the next chart. Set Axis Maximum to 5000 in all three charts. Now a bar of 3,554 is longer than a bar of 975 in every chart.