Just so we know where this is heading, this is the end result
And here is the file with the end result, you can download it and play around with pressing F9.
Here’s how we make it work.
We start with the data. Now we need to add two columns that will only show the min or max value and have blanks on other occasions.
The two formulas will be
MIN: =IF(B2=MIN($B$2:$B$13),B2,””) or if you write a table formula
MAX: =IF(B2=MAX($B$2:$B$13),B2,””) or if you write a table formula
Now we create a basic Column Chart from this data and we get
The order of the series is important, it should be
The first thing we need to do is to change colors of the MIN and MAX series.
Next, we change the Overlap and Gap Width properties of any series so that the columns overlap and…
View original post 123 more words