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.

Click here to download the Ultimate Speedometer workbook.
Watch step by step tutorial to learn how to create an Ultimate Speedometer chart in Excel: –