You can individually format each axis in a chart.
The chart type determines the formatting functions you can use for the axes. The formatting functions include the following:
For the value range you can specify values for an upper limit, a lower limit and an optimal value. Within the chart you can change these values as you change values for a data point - by moving the lines.
You specify the primary axes to be displayed in the chart using the chart options on the property pages.
You can also specify that a secondary axis is to be displayed. This is possible even if there is no data series for this axis.
Chart assigns an axis to a data series automatically; this is not something that the user has to do.
You can call up the formatting functions for an axis by double-clicking it.