Colors in Bar graphs

[#1]

Hello all,

I have a bar graph with values above 0 and below 0

I like the bars below 0 will be in red and the values abovewill be in green

My expression is a calculated

(sum(A) /above( sum( A))) -1

The graphis attached.

Thank inadvance.

T.

[deepakk · Accepted solution]

hi,

Go to Expression. Expand the plus sign next to expression.

In the background color add this code.

If (column(1) < 0 ,red() , green()).

You can aslo specify the rgb colors as rgb(100,102,123).

Please view the attachment for the further assitance.

Deepak

[jagan]

Hi,

In expression background color give the following expression

If((sum(A) /above( sum( A))) -1 >0 , RGB(0,255,0), RGB(255, 0,0))

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi

     Hope the attached file will be helpful for your requirement

Regards

Ashok

[#5]

thanks a lot

it was very hulpfull and quick.

Cheres,

T