y-Axis of a chart colourful?

[#1]

Hello Community,

is it possible to colour the y-axis of a Diagramm?

I want that some values for example 0-20 = yellow, 20-100 = green, -100 until 0 = red.

I added an example.

thanks for your help!

Best regards,

Aylin

[sujeetsingh]

Try setting the Axis color at Properties>>Axes>> and try using conditional coloringexpression

[jagan]

Hi,

It is not possible because you can only single color to axis, but one workaround is create an image of the axes and place on top of the axis in the chart, also you need to fix the X and Y axes Min and Max values in Axes tab.

Regards,

Jagan.

[sujeetsingh]

Jagan is right  i tried a lot but it seems you need to follow some visual tricks for this either go with image or just create lines with color transparent (means background color of Line object) but such tricks have limitations .

What when your axis grow?

[#5]

I tried this but it doesn't work:

(sum(Value)<20 and sum(Value)>0,green(),

if(sum(Value)<100 and sum(Value)>=20, yellow()))

[#6]

Thanks, this is an good idea. I will try this solution.