7 Replies Latest reply: Jul 1, 2014 8:14 AM by Mike Hennigan

displaying negative values in Gauge chart

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

• Re: displaying negative values in Gauge chart

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.

• Re: displaying negative values in Gauge chart

Here is an example.

• Re: displaying negative values in Gauge chart

hi mphekin12

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

• Re: displaying negative values in Gauge chart

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

• Re: displaying negative values in Gauge chart

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

• Re: displaying negative values in Gauge chart

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