Forum Discussion

Sperling's avatar
Sperling
Icon for Advocate II rankAdvocate II
3 years ago

Column chart with conditional colouring has wrong colour in legend

I have an issue with the legend colour.

My graph is pretty simple - just showing this years revenue as columns and last year as a line.

Here is my initial image without any conditional formatting, which looks right in the legend:

Image #1

 

 

Here I start making the conditional colouring of the columns, so it is possible to quickly see which months are ahead/behind last year:

Image #2

 

 

 

And here the output is. Looking at the columns it is fine, but the legend has went back to the default colour?

Image #3

Need Help

1 Reply

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    3 years ago

    Hi Sperling ,

     

    I don't think conditional formatting applies to legend color. You can overlay a shapes that mimic the conditional formatting color and a text in it as a workaround.