I have a simple gauge set up where I have 5 visible sections of a doughnut chart (representing commission bands). These commission bands are established based on the max sales for each band. Here are the bands I'm using, the commission rate is on the left, sales maximum on the right:
[TABLE="width: 152"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Start[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1.5[/TD]
[TD]20,000.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]30,000.00[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]37,500.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]45,000.00[/TD]
[/TR]
[TR]
[TD]3.25[/TD]
[TD]50,000.00[/TD]
[/TR]
[TR]
[TD]3.5[/TD]
[TD]100,000.00[/TD]
[/TR]
</tbody>[/TABLE]
I've overlayed the doughnut chart with a pie chart to create the gauage. The three values of the pie chart are the current sales amount, the needle size, and the difference of the maximum (100k)-(current sales+needle size). Rotate both charts to 270 degrees, and there you have it. This seems to be a very typical way of creating gauges from what I've seen online/on youtube.
However, the issue I'm running into is the needle is not moving at the correct rate. Let's say I have 15k in sales. That would fall in the first commission band. So my needle should be resting around the 75% mark of the first section of the doughnut chart. Once I breech 20k in sales, the needle should move into the next commission section of the doughnut chart and so on. However, I have a case where the total sales is 21k (2nd section commission band), but the needle is still sitting in the first commission band section. It has moved, but not moved enough I guess we could say.
Any ideas on why the needle is not moving as much as it should be? This may more difficult to answer without seeing the gauge and supporting data series, but I can't seem to find how I can attach the spreadsheet to the thread.
[TABLE="width: 152"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Start[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1.5[/TD]
[TD]20,000.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]30,000.00[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[TD]37,500.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]45,000.00[/TD]
[/TR]
[TR]
[TD]3.25[/TD]
[TD]50,000.00[/TD]
[/TR]
[TR]
[TD]3.5[/TD]
[TD]100,000.00[/TD]
[/TR]
</tbody>[/TABLE]
I've overlayed the doughnut chart with a pie chart to create the gauage. The three values of the pie chart are the current sales amount, the needle size, and the difference of the maximum (100k)-(current sales+needle size). Rotate both charts to 270 degrees, and there you have it. This seems to be a very typical way of creating gauges from what I've seen online/on youtube.
However, the issue I'm running into is the needle is not moving at the correct rate. Let's say I have 15k in sales. That would fall in the first commission band. So my needle should be resting around the 75% mark of the first section of the doughnut chart. Once I breech 20k in sales, the needle should move into the next commission section of the doughnut chart and so on. However, I have a case where the total sales is 21k (2nd section commission band), but the needle is still sitting in the first commission band section. It has moved, but not moved enough I guess we could say.
Any ideas on why the needle is not moving as much as it should be? This may more difficult to answer without seeing the gauge and supporting data series, but I can't seem to find how I can attach the spreadsheet to the thread.
