Skip to Content
Apr 14, 2016 at 06:29 AM

Gauge chart help


I am using CR 2013 and want to do a gauge chart and need some help.

Here is my data structure

Fund type Fund Total Fund used A Fund 1 5,000 2,000 A Fund 2 600 0 B Fund 1 25,000 20,000 C Fund 1 4,000 3,000 D Fund 2 800 500

In the gauge chart, the chart changed by fund type for each customer . The maximum value of the axis is the fund total by customer and by fun type with the fund used as the pointer. Basically, I want to show on the chart is the precentage of fund been used. 0-50% in red, 51-75% in yellow and 76-100% in green.

Is gauge chart the right chart to use? If so, how to do it? I added both fund total and fund used as the value to the chart. However, the max for the axis is either auto or manual input a fixed number, not based on a field.

Any help is appreciate.