gauge chart color change

[#1]

hi

i am trying to display a gauge chart as shown in the image.

the problem i have is i want the colors to change when the conditions are like this

100-25 -> green

24- 1 -> amber

0= red

can some one plz help me with this plzzz...

would really appreciate the help alot

thank you in advance

[israrkhan · Accepted solution]

Chart properties , presentation tab.

add 3 segments.

Segment 1 add value 0, and select color red

Segment 2 add value 1, and select color blue

Segment 3 add value 24, and select color green..

and in min value box add min value 1, and max value 100.

see in the image.. if not able to do, share your document, i will do it...

[israrkhan]

See Attached Sample

Hope it Helps

Kind Regards

Khan