Change the colour of a text in Chart

[#1]

Hi,

i have 2 question:

1)

i have changed with the formel

=if(column(1)<0,rgb(255,0,0),rgb(215,215,0)) for Background and Text. but it dosen't work for the Text.

(attached QlikView Chart Value2)

2)

i the Chart Value is the difference between max and min from Value too large, how can i change the Chart, that the Min (-15) is showing too.

Thanks very much

[disqr_rm]

1) your need to put same expression in the "Text Color" just as you have done under "Background Color".

2) not sure if this is possible. If you somehow can create 2 expression, then you can do split axes and show the negative ones in the splitted chart. Would that work?

[#3]

Hi Rakesh,

Thansk for your Help. it dosen't work. see my QlikView.

[disqr_rm]

Enclosed

[#5]

Hi Rakesh,

Thanks for your Help. it is Ok.