I am using CR 2013 and want to do a gauge chart and need some help.
Here is my data structureCustomer
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.