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

Note: This option can only be used for line charts and area charts.

You can use the options for lines, for example, to illustrate the spacing between the individual data series in a line chart.

The following types of lines are available:

▪Drop lines are lines displayed from the data points to the horizontal axis.

▪High-low lines are lines displayed between the highest and lowest data points (for two or more data series).

To show/hide drop lines or high-low lines, proceed as follows:

Via the "Add chart element" icon

Select the chart and use the ribbon command Chart | Add chart element to choose the entry Lines. In the following submenu, you can choose between Drop lines and High-low lines. A check mark in front of it indicates the option which is currently enabled.

You can hide the lines by selecting the entry None.

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

Via the dialog box

For additional options, choose the path via the dialog box:

For more information on the options of the dialog box, see Data series and data points, "Options" tab.