Excel Min Max Diagramm. Right click the chart select data edit the horizontal category axis labels and change the range to reference cells a41 b64. Select the data in cells b40 e64 insert a 2 d column chart step 2.
The formula in cell c2 copied and pasted in c3 c10 is. If b2 max b 2 b 10 b2 na which puts the value of column b into the same row of column c only if it s the maximum value in column b. Excel column chart with min max markers step 1.
This chart type is used by engineers and scientists.
So the formulas appear to be working properly because the min and max values on each axis are correct but the secondary line is still not appearing. Right click the chart select data edit the horizontal category axis labels and change the range to reference cells a41 b64. Within the bounds section manually input your minimum and maximum axis limits. An average max min chart displays the average maximum and minimum values where the average is plotted with greater importance.
