Now, select the scale (numbers in the gauge) and right-click on it to display its context menu. On the Radial Scale Properties dialog box, set its Maximum value to that of the [SUM(SalesQuota)]
. Before you save and close the dialog box, format the number. Don't put decimal and show its value in Millions.
You probably get the idea of what the relationship is between the pointers (Sales YTD / Sales Last Year) and scale (SalesQuota
). The pointer indicates how far or close the value (SalesYTD / Sales Last Year) is to its target or goal (SalesQuota
).
3.141.35.185