7 Replies Latest reply: Aug 18, 2014 9:55 AM by Pedro Barabanov de Assis

# Color of a legend in a chart

Hi, everyone!

I have this problem, where I used the formula "=IF(Nome_Administradora_UF = 'DISAL  ADM CONS LTDA',Green())" to change the color of only the items where named "DISAL  ADM CONS LTDA". I put this formula in the background color of a expression.

The problem is in the legend, where all items gets the unique color when this "DISAL  ADM CONS LTDA" is in the chart, just like this:

Someone know how to "fix" this problem? How can I get the correct colors?

• ###### Re: Color of a legend in a chart

HI Pedro

Do you have two dimensions?

Try to change the order of the dimensions.

Thanks and regards

• ###### Re: Color of a legend in a chart

I have two dimensions, but I can't change the order. If I do that, the chart doesn't suport what the client wants.

The client wants the chart showing the top 10 sellers by a quarter.

• ###### Re: Color of a legend in a chart

Hi Pedro

Can you set up the top 10 as a dimension limit

Thanks and regards

• ###### Re: Color of a legend in a chart

Yeah, I did that. THe problem is that the client wants to see the sales of each one of this top ten, just like the first picture. The chart was correct. Just the color in the legend (all green) is the problem. If the item "DISAL" is not in the top 10, the problem doesn't occur.

• ###### Re: Color of a legend in a chart

the color of legend is his heart, think about that.

• ###### Re: Color of a legend in a chart

Hi,

Can you please post your app, because  its giving rite for us.

• ###### Re: Color of a legend in a chart

Hi, Avinash!

It's too much big to post here!

But the problem is just that: I used a formula to change the color of only one seller (DISAL), but I need the color of the legend like the other itens. One color per quarter/year. When we have Disal item, the color of the bar is changed to green (and it's ok, i'ts what we want), but the color in legend change too (that is what we don't want).

Can you see the pictures above?