2 conditions color for bar graph (positive/negative AND total bar)

[#1]

Hi,

In a bar graph, how can I have different colors for positive and negative values AND at the same time have a different color for the Total bar?

Thanks.

[sushil353]

Hi,

In the expression tab: expand + sign of expression and define the desired color in background of expression.

you can use RGB() for specific color.

HTH

Sushil

[#3]

I'm in the tab (for Background color) using IF conditions and RGB function but don't manage to obtain the right result... I don't use If condition correctly I think...

= if(Dimensionality()=0,RGB(27,125,156),

if([Dim]>=0,RGB(255,0,0),RGB(0,185,0))

[sushil353]

Try to use expression in your if condition ..

say your expression is sum(values) then

=if(sum(Values)>=0,RGB(255,0,0),RGB(0,185,0))

[PrashantSangle]

Hi,

Dont use Dimensionality() it servers for different prupose.

Write your expresssion which calculating +,- value in if clause

Like this

IF(Your expression>0,RGB(27,125,156),RGB(255,0,0))

Regards,

[#6]

That works well to have different color for positive and negative values. But I don't manage to change (on top of that) the color of my total bar... (I manage to do one or the other but not both at the same time...)

[#7]

I'd like to have green for positive Value, Red for negative value and Blue for the total bar on the right....

Thanks again for your support...

[PrashantSangle]

Hi,

what is your expression?

can you share sample file?

Regards,

[#9]

[PrashantSangle]

Hi,

can you tell us what is your expression which gives your +,- Values

Not your Background expression.

Also check in Help menu.what is use of Dimensionality()

It returns

number of dimension columns that have non-aggregation content. i.e. do not

contain partial sums or collapsed aggregates

Regards,