Color setting on lollipop graphs

Hi All

 

Why is it that when i try to set color rules on my lollipop graph no matter what values i put in as the rule it still displays the one color? I set red for <= 80 and green for >=81. The value is a percentage based on a beast mode calculation.

 

Any help appreciated!

 

Cheers

Paolo

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    Paolo,

     

    A couple of things to check. With your percentage calculation, are you doing the 'Multiply by 100' option in the column format as shown below or multiplying by 100 within the beastmode?

    image.png

    If it's in the column options as shown below, you may need to change your rules to <=.8 and >= .81

     

    Second question. Which lollipop chart type are you trying to use? And if it's one with lines, are you setting the bar or line color? That should help moving forward if the first suggestion doesn't do it.

     

    Just let me know if you need more help,

    ValiantSpur

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    Paolo,

     

    A couple of things to check. With your percentage calculation, are you doing the 'Multiply by 100' option in the column format as shown below or multiplying by 100 within the beastmode?

    image.png

    If it's in the column options as shown below, you may need to change your rules to <=.8 and >= .81

     

    Second question. Which lollipop chart type are you trying to use? And if it's one with lines, are you setting the bar or line color? That should help moving forward if the first suggestion doesn't do it.

     

    Just let me know if you need more help,

    ValiantSpur

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • Fantastic that worked thanks!

This discussion has been closed.