Learn how to change the scale of a chart in Microsoft Excel

In this video tutorial we will show you how to change excel chart scale.
In order to change excel chart scale, open your excel document. Select a column with data. Go to the "Insert" tab. Click on "column" and choose "3-D Column".

Adjust your chart size. Then, go to the "Layout" tab. Click "Axes", choose "Primary Vertical Axis" and select "More Primary Vertical Axis Options". Select "Minimum" parameter to "Fixed" and set value "10000.0". Then change the "fixed" parameter to "Maximum" and set the value to "100000.0". Go to "Axes" again, choose "primary vertical axis" and select "More Primary Vertical Axis Options". Change "Major unit" to "Fixed" and set the value to "5000.0". Now open the "axes", choose "primary vertical axis", select "more Primary Vertical axis Options". Change "Minor unit" to "Fixed" and set the value to "5000.0"

Now you know how to make changes in the excel chart scale.

свернуть