Changing the scale of the secondary axis is easy. Here is what you need to do: Right-click on the secondary axis. Select the Format Axis option. Select the Axis Options tab. Under the Vertical Axis Crosses section, select the value for the secondary axis to cross. Select the type of scale you want to use (linear or logarithmic). Enter the minimum and maximum values for the secondary axis. Click on the Close button.