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.
#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