Adding a scale for the gauge

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.

Adding a scale for the gauge

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).

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.141.35.185