Axis Config is a button in the Worksheet Options pane and allows users to edit the position of a series in a chart. By selecting the Axis Config button, users can open the Axis Config tab or the Scale tab and can change the axis and scale of a series by checking the appropriate axis selection. Users can return to the Configuration window by selecting the Back to Configuration button, or by selecting the Configuration button from the toolbar.

Scale Tab

The user has control of the chart Y-axis. To change the scale of the Y-axis, select the Axis Config button in the Worksheet Options pane. Select the Scale tab and change the mode from Automatic to Manual. In the Min and Max fields enter the amounts for the scale of the Y-axis.