How to change Excel 2007 Chart Scale

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”.

Choose the 3-D Column type

Adjust your chart size. Then, go to the “Layout” tab. Click “Axes”, choose “Primary Vertical Axis”

Choose the Axis Type

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.