Lines (max-min)

This type of Excel graphic is commonly used to plot maximum, minimum values in the data.
This Excel graphic works with 2 series as it is shown.

1.Group your data with the structure as shown in the example.
2.Select the data source.
3.Choose where to insert the Excel chart.