And either clicking somewhere else or pressing Enter we see how the chart has reacted immediately. I'm going to change the maximum here to be 350. Here are the automatic scaling numbers that we see here.
![change the display of the vertical axis in excel for mac change the display of the vertical axis in excel for mac](https://bbfasr843.weebly.com/uploads/1/2/4/1/124117776/570320748.png)
It gives us some choices related to bounds. But if we want to cut to the chase and get there quickly, simply double-click one of the numbers down the left-hand side, and watch that Format Axis dialog box on the right.
![change the display of the vertical axis in excel for mac change the display of the vertical axis in excel for mac](https://i.stack.imgur.com/ScQlC.png)
Now there's nothing wrong with going down this path, but if we go to More Axis Options, and by the way, rarely will you want to turn these off, so I think for the most part you pretty much ignore those, More Axis Options activates a dialog box on the right-hand side with lots of different choices. Now first thought might be, why don't we select the chart and then use Chart Design in the menu, and add Chart Element because we've got an axis choice out here. Maybe these are the real numbers, but we don't want the chart to go to 400, we want it to go to 350. You'll see how it kicks back and goes back to its previous setting. And the chart below, which is covering the same data, it happened there too. The rescaling kicks in, we automatically see a new scale. If the June number here got adjusted from 340 to be 410, for example, as soon as I press Return watch the chart to the right. For example, in this green chart, the scaling automatically kicks in. We see these on many chart types in Excel, and usually what we see is what's called automatic scaling. The horizontal axis across the bottom, sometimes called the category axis.
![change the display of the vertical axis in excel for mac change the display of the vertical axis in excel for mac](https://www.get-digital-help.com/wp-content/uploads/2015/08/custom-data-labels-x-y-scatter-chart-workarounf-or-excel-2010-and-2007-link-1.png)
The vertical axis down the left-hand side of a chart like we see on this worksheet called Profits is sometimes called the value axis. In Excel charts you can control the display of axes.