Gauge Chart - how can I set maximum as being a target

[janet_donbavand]

I would like to use a gauge chart as an indicator of how close our fundraising is to the target. I tried to do this by setting the maximum of quality band 5 as our target figure but it didn't like it. Any ideas as to how I might achieve this? Thanks in advance.

[former_member260594 · Accepted solution]

Hello Janet,

If the band maximum is greater than the maximum data value then it will not plot the range. Try going into the Chart Expert > Axes > Uncheck Auto Range and increase the Max to your desired value.

Regards,
Graham

[janet_donbavand · Accepted solution]

Hi Graham

I got there in the end. I created a formula field with the various target figures for the group field, then one as % of target figure and made this the gauge chart field did the Uncheck Auto Range and put Max to 100.

Thanks

Janet