Overlaid Chart Speedometer needle will not update with value change

[run2win17]

I have a chart "speedometer" I was able to replicate using instructions online but when I change the input value, the chart will not update. I can attach the file if that is easier and possible; the cell I am changing is AA4, but you would notice the needle stays in the same place, does anyone have any suggestions? Also, I'd love to have the needle's value displayed right outside where the needle is pointing if anyone has any suggestions for that either.

Thank you!
Ben

 

[DRSteele]

Welcome to the forum.

Perhaps the contents of this link might help you make a satisfactory speedo chart. https://www.mrexcel.com/forum/excel-questions/1001508-excel-speedometer-gauge.html#post4808168

 

[run2win17]

This works much like the other one I did, but when I update the "input cell" the needle still doesn't move to the correct position. When I set it up, I set it at 50 which would be straight up, and the needle was appropriately pointed straight up. However, now that I changed the input cell value to 20 it remains straight up and unmoved.

Any thoughts?
Thanks for your help!

 

[DRSteele]

Does it update after you press f9? Perhaps you don't have the workbook's Calculation set to automatic.