Charts: Minimum or Maximum Value

You may want to set a minimum or maximum value for an axis in your chart.

Here's a list of which types of charts on which you can set the maximum/minimum y-axis / x-axis values: 

Vertical bar chart : y-axis only

Triangle bar chart : y-axis only

Horizontal bar chart : x-axis only

Line chart : y-axis only

Area chart : y-axis only

Dot chart : y-axis only

Scatter plot : x-axis and y-axis

To do this, first double-click your chart to edit it. Click the Settings gear in the top right corner of the chart pop-up window. Then, you can enter the minimum and/or maximum y-axis/x-axis value for your chart.

For the x-axis values, you can increase the width of the chart by clicking and dragging the round handlers on the right or left of the chart. For the y-axis values, you can do the same, increasing the length of the chart by clicking and dragging the round handlers on the top or bottom of the chart. The labels will automatically adjust to the available space.

The custom minimum/maximum values of a chart are independent of any value in the grid. This allows you to reflect data in the way you want it. The value for the minimum/maximum is allowed to be higher or lower than the lowest/highest value.

You can include decimal values and adjust the scale/axis accordingly. Here's more information on our Chart makeover.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.