Colour change depending if beating last years amounts

kav_100
kav_100 Member
in Charting

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.

Screenshot (2).png

Tagged:

Best Answer

  • michiko
    michiko Contributor
    Answer ✓

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

    image.png

    #2 - Create some fancy beast mode calcs

    image.png

    image.png

    #3 - Define the color rules

    image.png

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

    image.png

    Tadaaaaaa

Answers

  • michiko
    michiko Contributor
    Answer ✓

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

    image.png

    #2 - Create some fancy beast mode calcs

    image.png

    image.png

    #3 - Define the color rules

    image.png

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

    image.png

    Tadaaaaaa

Categories