Showing/hiding axes and axis titles

Navigation:  Charts > Editing charts > Showing/hiding chart elements >

Showing/hiding axes and axis titles

Previous pageReturn to chapter overviewNext page

The horizontal X axis of a chart is also known as the category axis.

The vertical Y axis of a chart is also known as the value axis.

The Z axis of a chart is also known as the series axis. It is only available for certain three-dimensional chart types.

Note: The X axis and Y axis are shown automatically when the chart is created.

To show or hide an axis, proceed as follows:

Via the "Add chart element" icon

You can use the Add chart element icon chart_add_element_icon on the contextual ribbon tab Chart to show or hide the X axis and/or Y axis (the Z axis only in the dialog box, see below).

To do so, select the chart and use the ribbon command Add chart element chart_add_element_icon to select the entry Axis. In the following submenu, you can use the entry Primary horizontal to show or hide the X axis and Primary vertical to show or hide the Y axis.

The entry More takes you to a dialog box with additional options (see below).

Axis title: To add, change or remove axis titles, proceed as follows:

Adding axis title

If you want to add an axis title to the axis, choose the ribbon command Add chart element and then select the entry Axis title. Primary horizontal shows an axis title for the X axis, while Primary vertical shows it for the Y axis.
The entry More also takes you to the dialog box here (see below).

Changing an axis title

To rename an axis, double-click on the axis title and switch to the Text tab in the following dialog box. Enter the desired text here.

Removing an axis title

To remove an axis title, hide it again via the command Add chart element or select it directly in the chart and press the Del key.

Via the dialog box

For additional axis options (for example, the Z axis or secondary axes), choose the path via the dialog box:

1.Select the chart by clicking on it.
2.Use the ribbon command Chart | Add chart element chart_add_element_icon to choose the entry Axis (or Axis title) and select More in the following submenu to open the dialog box.
Alternatively: Right-click to open the context menu and select the entry Chart: Properties.
3.Switch to the Elements tab.
Axes: The checkbox in front of each axis can be used to enable/disable the display of the relevant axis.
Axis title: To the right of the axis, you can give it a name. This will then be displayed below/next to the axis.
For more information on the options of the "Elements" tab, see Chart properties, Elements tab.

Editing axes and axis titles

For more information on editing the properties of axes, see Category axis (X axis), Value axis (Y axis) and Series axis (Z axis).

For information on editing the properties of the axis title, see Axis title.