Pointer in Speedometer Chart

[Thomas Kuriakose]

Respected Sir,

We have a speedometer chart displaying the below values-

Actual - 126
Target- 2043

The pointer is not getting aligned with the value for actuals.

Kindly let me know how to get this aligned.

Thanks,

with regards,
thomas

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[Thomas Kuriakose]

Respected Sir,

Thank you for this input, but we need the pointer to be aligned with the value 126 in the do-nut chart.

The Actual value will be input in cell B3 and the pointer should follow the value in the do-nut.

Thank you very much,

with regards,
thomas

 

[Nebu]

Hi:

Sorry my bad. have corrected it.

Thanks

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for this solution.

Thanks once again.

with regards,
thomas