Lines (max, high, average, low, min)

This type of Excel graphic is commonly used to plot maximum, minimum, average, high values, low values in the data.
This Excel graphic works with 5 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.