Note: This option can only be used for line charts.
You can use the option Up/down bars to display bars between the first and last data series, for example, in a line chart with two or more data series.
To do so, 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 Up/down bars. In the following submenu, select the same entry.
You can use the entry None to remove the up/down bars.
The entry More takes you to the dialog box (see below) where you can also set the spacing between the bars.
Via the dialog box
Choose the path via the dialog box to make further settings:
| 1. | Select the chart by clicking on it. |
| 2. | Use the ribbon command Chart | Add chart element to choose the entry Up/down bars and select More in the following submenu to open the dialog box. |
| Alternatively: Select any data series and right-click to open the context menu and select the entry Series: Properties. |
| 3. | Switch to the Options tab and enable the checkbox in front of Show up/down bars with gap. In the input field below, you can set the gap between the bars. |
For more information on the options of the dialog box, see Data series and data points, "Options" tab.