Charts > Editing charts > Editing chart elements

The Y axis of a chart is also called the value axis.

Tip: For more information on showing or hiding axes, see Showing/hiding axes and axis titles.

Changing properties: To change the properties of the value axis, select it, right-click it and choose the command Value axis: Properties from the context menu.

Tip: Alternatively, you can choose this command via the Edit properties icon on the ribbon tab Chart | group Chart elements. The other alternative is to double-click on the axis.

You can make the following settings:

Format tab

Tip: Lines can also be conveniently adjusted directly via the buttons of the ribbon tab Chart | group Chart elements. For more information, see Editing chart elements.

▪Line section

Here, you can change the line style used to draw the axis. Auto uses a thin gray standard line. None removes the line. The option Custom lets you customize the line style.

▪Major ticks and Minor ticks sections

Here, you can determine whether small tick marks should be displayed to divide the axis and specify their appearance.

▪Tick labels section

Here, you can determine whether axis labels should be displayed and where to place them.

Scale tab

You can use this tab to change the scale of the axis.

▪Lowest value and Highest value sections

These options determine where the visible part of the axis should begin and where it should end. Select either the option Auto, which results in Write automatically determining the most appropriate values, or select Custom and enter the desired value yourself.

▪Intersection between X and Y axis section

You can use this option to determine where the X axis (category axis) should intersect the Y axis (value axis):

If Auto is selected, Write automatically determines the most appropriate value, and if Maximum value is selected, the X axis is positioned at the end of the Y axis. You specify your own Y value if you select Custom value.

▪Major step value section

Here, you can set the interval for the tick marks and labels on the axis. If you select the option Auto, Write automatically determines the most appropriate values.

▪Minor step value section

Here, you can set the interval between minor tick marks on the axis. If you select the option Auto, Write automatically determines the most appropriate values.

▪Invert axis direction

If this option is enabled, the direction of the axis is reversed. In a column chart, for example, the columns are no longer drawn from bottom to top, but from top to bottom.

▪Logarithmic scale

If this option is enabled, the axis will use a logarithmic scale (for example, 10, 100, 1000, etc.) rather than a linear scale.

Font tab

You can use this tab to change the formatting of the axis labels.

In addition to font, font size, and text styles, you can also set the alignment, rotate the labels and change the numeric format.

Value axis (Y axis)

Value axis (Y axis)