Colour change depending if beating last years amounts

kav_100

I have a bar graph with a comparison line showing the previous year. I want the bar to show a different colour depending on if were beating the previous year or not. e.g. red if under and green if over.

michiko

#1 - Structure your data like this ( ie add a column called LY Amount )

#2 - Create some fancy beast mode calcs

#3 - Define the color rules

#4 - And finally… hack the hell out of the Line + stacked bar chart.

Tadaaaaaa