How to set color in gauge chart ??

[#1]

Hi,

I have a situation in which i want to show values from 0-60 in green color and 60-100 in red. How can i achieve it in gauge chart??

[MK_QSL]

Go to presentation tab

Untick Autowidth Segments

Go to Top for Segments Setup

Make sure you have two segments i.e. Segment 1 and Segment 2

Segment 1 - Lower Bound = 60 and Color Green

Segment 2 - Lower Bound = 100 and color Red

Gauge Settings

Min 0

Max 100

[#3]

Thanks Mainsh,

I have one more question. if i want to achieve it thorugh expressions. How cn i do it??

[MK_QSL]

Consider that you have sales....

Min = 0

Max = SUM({1}Sales)

1st Segment Lower Bound = SUM(Sales) * 0.60 or SUM({1}Sales) * 0.60

2nd Segment Lower Bound = SUM(Sales) * 1.00 or SUM({1}Sales) * 1.00

Haven't tried but obviously you can... !!! let me know if you are not getting it dynamically ...

[#5]

Manish thanks for your help.

As per the requirement i want to show the output of my expression of the chart in green color and values above the output in red.

For example if the output of the chart is 26. The green color must be upto 26.

If the output changes with data refresh to 30, the green color must be upto 30.

It will be dynmic color mapping.

[MK_QSL]

make three segments

for 1st Segment Lower Bound 0 and color green

2nd Segment Lower bound =SUM(Sales) and color red

3rd segment lower bount = SUM({1}Sales) and color red...

if not working, let me hv your sample data file...

UPDATE : pls check enclosed file.. Ignore reply with three segments... use this file...