Min Max Range Chart Excel. Add supporting columns for max and min values to highlight maximum and minimum values in the excel line chart we. So select the tabular data and click on insert chart and select area chart just the simple area chart not the stacked area chart 3.
An avg max min chart type can be used when an uneven number of data records exist when gaps exist in the data or when insufficient samples exist for a more complete analysis. Select your source data and add a scatter chart with clicking the insert scatter x y and bubble chart or. Add supporting columns for max and min values to highlight maximum and minimum values in the excel line chart we.
Excel line chart with min max markers step 1.
Click on the max. The chart has three series but min and max don t appear because there is only one point in each and a line is the shortest distance between two points. Select the data in cells b5 e29 insert a line chart with markers step 2. A formula which exists on the worksheet to control the min and max values of a chart axis.
