displaying negative values in Gauge chart

[#1]

hi

i am trying to show minus values in Gauge chart. at present i am displaying the positive values as the below shown image (which is in blue)

is there any way of showing the minus (negative) values as shown in the second image(shown in orange)??

if some one could help me in this i really would appreciate... thank you in advance

[mphekin12]

Maybe try using the fabs() function.  This will convert the negative value to a positive one so that the chart will render.  You can then make the color in the Presentation tab a Calculated color, aqua for positive and orange for negative.

Hope this helps.

[mphekin12]

Here is an example.

[#4]

hi mphekin12

i am using a personal edition. will you be able to send me some screen shots plzz

[#5]

In Presentation tab give minimum guage setting as -1 and maximum as 1

[Anonymous]

Hi, Try below,

Segment 1 = 0%

Segment 1 Color = Orange

Segment 2 = 85%

Segment 2 Color = Transparent

Center Angle = 75 degree

Angle Span = 360 degree

PS: Your expression should be 1 i.e 100% always otherwise this will not work.

Hope this helps you

[#7]

the thin is i am am taking the value from an equation

=if(F=0,

num((sum( Actual)

)

/

sum( Budget),'##0.##'&'%'),

num((sum( FinActual)

)

/

sum( Budget),'##0.##'&'%'))

the positive values can be seen but not the negative values

[mphekin12]

Will this screen shot work for you?