Gauge Chart

[#1]

Hi,

Can somebody temmg me how Gauge chart deals with -ve values and +ve values both at a time.

I have minimum as -100% and maximum value as 200%.

So i wil put -1 as min and max as 2. Now i want to set lower bount something , So that i wil get red(<75%),yellow(>75 and <95), and green(>95).

Not able to set lower bounds with -ve value percentages. If possible can somebody help me out in giving any sample file illustrating the example with gauge settings.

Thanks in Advance

Suneela

[MayilVahanan]

HI

Do you want something like attached??

[#3]

In the attached app you given Min as -100 and Max as 300 . But I want to give as -1 and 3 respectively. Now the lower bound showing is my concirn as decimals so that it can give me in percentages.

I have the values as -0.30,-0.50,-1.00,0.75,0.85 etc.   So the lower limit in this case is -0.5 and upper limit is 1 as I have upto nearly 0.95 value. So based on this lower bound and upper bound setting is not working.

[#4]

In the attached app you given Min as -100 and Max as 300 . But I want to give as -1 and 3 respectively. Now the lower bound showing is my concirn as decimals so that it can give me in percentages.

I have the values as -0.30,-0.50,-1.00,0.75,0.85 etc.   So the lower limit in this case is -0.5 and upper limit is 1 as I have upto nearly 0.95 value. So based on this lower bound and upper bound setting is not working.

[#5]

<.75 is red >.75 and <.95 yellow and >.95 red. I want to show this.....

[#6]

if I wil get -ve values it should fall under red category...Please suggest by example.

[MayilVahanan]

Hi

Can you check now..

Its not satisfy your requirement.. Can you please post a sample file?

Edit:

Just now i saw your requirement..

Now check the attached file

[#8]

thanks .

Can you make one more segment for red which will fall below .75 and -ve. Yellow should be >.75 and green >.95.

Thanks in Advance.

[MayilVahanan · Accepted solution]

hi

check the attached file..

hope that helps

[#10]

Thanks a lot.Now i got it.