Highlighting the Top Value in a Graph

[#1]

Hi everyone,

I hope you can help me.

I try to make color of the top value of a bar graph a red color and the rest of them a greyish one. How can I do this? Is there a way to use some kind of a rank formula, like e.g. rank1 = red, for all others usw grey?

The problem is that with every selection you make, the top value changes. And so does the datafield do.

Best wishes

Daniel

[its_anandrjs · Accepted solution]

Hi,

Write some thing like this in the background option for colors

=if ( ( sum(Val) = Max( Total Val ) ) , red( ) , green( ) )

HTH

Regards

Anand

[its_anandrjs]

Hi,

See the attached sample file

And let me know

HTH

Regards

Anand

[#4]

Thank you really much! That is what I was looking for 🙂

[its_anandrjs]

Hi,

Thanks i am glad to help you and it works for you.

Regards

Anand