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.
 
Example