MICROSOFT EXCEL
Show minimum and maximum values in bar charts
You can use colours in Excel bar charts to highlight the highest and lowest values. First, enter your data into a table and create three additional columns with the headings Maximum, Minimum and Other.
In our example, we typed =IF(B5=MAX($B$5:$B$11),B5,"") in cell C5, which is in the Maximum column. This checks whether cell B5 shows the highest temperature in the range B5 to B11. If so, the maximum will appear in C5. If not, it will be left blank.
We then repeated this in cell C6, changing B5 at the end and beginning to B6 (for example, =IF(B6=MAX($B$5:$B$11),B6,""), and so on down column C. We did the same in the D column (Minimum), changing MAX to MIN (for example, =IF(B5=MIN($B$5:$B$11),B5,"").…
