Dial / Speedometer Chart - Segment (Pie) Proportions and Accuracy of Dial

Hi

Please see attached
Gauge_Dial Chart_ROS_ vForum.xlsx

1st Question
I would like to get proportional sizes on my dial charts but am not sure how to do this as I can't figure out how to apply value ranges for each segment

e.g.
I would like the start point to be 10%, therefore first segment would have a range starting at 10% - 13.4%, then as follows:

2nd segment: 13.4% to 14.4%
3rd segment: 14.4% to 16.5%
4th segment: 16.5% to 20%

2nd Question

On the chart I have selected an actual of 15%, which means it should be in Green segment but it's in Amber. Am not sure what I'm doing wrong.

Can anyone offer some advice please

Thanks, M

Your Stats Minimum values should be based on the % of each tier, with total add up to 100% - please refer column G added.

For Pointer, Start value should directly refer to the input value in C3 and End value the maximum value of 20% multiplied by 2 minus sum of Start and Width/2 values.

HI
Since we want to start at 10% and finish at 20% I created a donut chart where 10 parts
they have the same size (10) and one part is equal to the sum of the previous ones.
I assigned the numbers 10 to 20 as labels.
The pie chart takes data from cells G3:G5. In these cells there are the following formulas:
cell G3 =SE(O(H3<0,1;H3>0,2);"Error";((H3*100-10)*180/10)-G4/2)
report error if entered number less than 10% or greater than 20%
cell G4 =360-SUM(G3:G4)
round angle minus the sum of start and width

Hi,
Mario