Gauge Chart

[#1]

Hi,

Can somebody please help me to format the actual result, which is visible in the Chart Title window, in percentage. I have the scale of the gauge chart in percentage but don't manage to have the actual result in percentage. Or is there a way to present the actual result next to the chart?

Thanks and Krgds,

Lennart

[CELAMBARASAN]

Hi,

     Use the expression you have used in the title like

     =Num(Expression,'###.##%')

     Its better to use it in the Text in Chart option.

     Properties-->Presentation tab

Hope it helps

Celambarasan

[#3]

Hi Celambarasan,

This worked great, thanks a lot for your help.

By the way, would you know how I could restrict the values being shown to only a certain time period? Right now the value being shown is the accumulated values of all of 2011 and also Jan-2012. But I would like this gauge chart to only show the values for 2012.

Thanks again for your help, most appreciated!

Krgds,

Lennart

[CELAMBARASAN]

Hi,

     What expression are you using?

     You expression may be like Sum({<Year={'$(=Max(Year))'}>} Sales)

     Add the bold part to your expression.

Celambarasan

[#5]

Hi Celambarasan,

And thanks again, your suggested script worked absolutely perfectly!

Thanks and Krgds,

Lennart

[CELAMBARASAN]

Hi,

     Close this discussion by mark it as correct answer which will help others who looking for same type of solution.

Celambarasan

[#7]

No problem, but how do I mark it as a correct answer…. Thanks!

[CELAMBARASAN]

Hi,

     On my post you seen correct answer and helpful answer button.

Celambarasan

[#9]

Hi,

I’m afraid I don’t see any such buttons….don’t know whether it has anything to do with my settings or whether the webpage is experiencing any problems.

/L