Excel Speedometer Gauge - urgent help

Hello,
I have created some excel speedometers that my company has requested for their KPI's but for some reason I'm struggling to get the speedometer needle to match my data targets. Please anyone who can help me on this will be very much appreciated. I've enclosed my speedometer excel sheet for your reference. The main sheet has the main speedometer which works absolutely fine, click on the drill button to go into detailed speedos and this is where my problem is and im struggling to get my head around this. Please help!!!

Thanks in advance.

Regards

Afroz

Hello Jeff,
Thanks for responding. I've enclosed the speedometer gauge excel document above. Are you not able to access it? If not I can send it to you by email if you are happy for me to send it that way. Please let me know.,
Regards

Afroz

I could open your document just fine. All you said is "this is where my problem is." You need to be more specific, because I am looking at your document and the charts look OK to me.

Describe the details for at least one chart that you think is incorrect. Tell me which chart to look at, tell me what you think it should look like, and where you think the data should be coming from.