block chart

[NavinReddy]

Dear Experts ,

I have an Issue I am creating block chart,here i have some negative values

How to show in block chart negative values in red color

Please find the image

Thanks In Advance

Niranjan

[JonnyPoole]

little confused. if you have both positive and negative values in the chart you will get an error:  "positive and negative values in the chart'.

your screenshot shows a positive number.

also are you trying to change the color of the block or the label/number that sits in the block ?

please elaborate a bit more on your need .

[israrkhan]

Have you tried, in expression>> Text Color,, type expression like below.

if(sum(sale) < 0,Red(), Black())

[NavinReddy]

Hi,

i tried but its changing full text color ,but i want to change the only value color

Please find the image

Regards,

Niranjan

[NavinReddy]

Hi Jon,

Chart showing like positive only because if its negative block chart wont work

But in chart negative values also there ,

Those values i want to show in Red Color

please find the image

Regards,

Niranjan