Colour change depending if beating last years amounts

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.

Best Answer

  • michiko
    michiko Contributor
    Answer ✓

    #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

Answers

  • michiko
    michiko Contributor
    Answer ✓

    #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