Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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
Thanks Mainsh,
I have one more question. if i want to achieve it thorugh expressions. How cn i do it??
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 ...
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.
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...