Friday, June 17, 2011

Bar/line chart improvement

Bar/line charts are quite useful when we want to show the development of 2 variables on different scales or units of measurement. By default Excel gives you the left chart, which is kind of ok, but I have 'developped' a better version on the right, which limits the charts at the min and max of the each series and draws a line in the mid point of the range (Median or average won't work here because they might not be on one line).

Also note how the colour font on the axis labels gets rid of any legend box.