Ultimate Speedometer is one of my favorite visual. This speedometer has been created in Excel with help of auto-shapes. We have not used any type of chart to create this. To rotate the needle of speedometer, a small VBA code has been written in the change event on worksheet.
Ultimate Speedometer in Excel
Below is the snapshot of our ultimate Speedometer chart. You must enable the VBA from security to use this chart.
Visit our YouTube channel to learn step-by-step video tutorials
Watch step by step tutorial: