How to How to Create Speedometer Charts in Excel in Excel - Practical Guide

Learn to create professional speedometer charts in Excel to visualize KPIs and performance metrics at a glance. Speedometer charts are gauge-style visualizations that display progress toward a goal, making them ideal for dashboards and executive reports. This tutorial covers creating them using doughnut charts with custom formatting for a polished, professional appearance.

Why This Matters

Speedometer charts enhance executive dashboards and KPI tracking by providing instant visual feedback on performance against targets. They're essential for business intelligence reporting and stakeholder presentations.

Prerequisites

•Basic Excel knowledge and data entry skills
•Familiarity with chart creation (Insert > Charts)
•Understanding of data ranges and cell references

Step-by-Step Instructions

Prepare Your Data

Create three cells with values: Current Value (e.g., 75), Maximum Value (e.g., 100), and Remaining (formula: =B2-B1). These represent the speedometer's progress and total capacity.

Insert Doughnut Chart

Select cells B1:B3, go to Insert > Charts > Doughnut, and click Insert Doughnut Chart. Excel will create a basic doughnut chart with three data segments.

Customize Chart Series

Right-click the chart, select Edit Data, and adjust your data labels if needed. Remove the legend by right-clicking it and selecting Delete, then remove gridlines via Chart Design > Add Chart Element > Gridlines > None.

Format the Gauge Appearance

Right-click the doughnut ring, select Format Data Series, set Angle of First Slice to 270°, and Doughnut Hole Size to 70% for a speedometer effect. Adjust colors: Current Value (green), Maximum (light gray), Remaining (transparent/white).

Add Text Labels and Polish

Insert a text box in the center showing the current value and target (Insert > Text Box). Format axes labels via Format Data Labels to show percentages, and adjust font sizes for readability on dashboards.

Alternative Methods

Using Pie Charts as Base

Create speedometer charts using pie charts instead of doughnuts by inserting a Pie chart and formatting it with a center circle overlay for similar visual results.

Third-Party Add-ins

Use Excel add-ins like Microsoft 365 Charts or Charticulator for pre-built speedometer templates that require minimal customization.

Tips & Tricks

✓Use conditional formatting on your data cells to auto-update gauge colors based on performance thresholds.
✓Create a dynamic formula so the speedometer automatically updates when source data changes.
✓Place speedometer charts on dashboards alongside KPI labels for maximum impact in executive reports.

Pro Tips

★Create multiple speedometer ranges with different color zones (red, yellow, green) to show risk levels at a glance.
★Use the speedometer in combination with a data table below showing historical trends for comprehensive KPI analysis.
★Save your speedometer as a template (File > Save as Template) for quick reuse across projects.

Troubleshooting

Chart doesn't update when data changes

Ensure your data range is dynamic by using named ranges or Table references instead of static cell ranges. Go to Formulas > Define Name to create a dynamic named range.

Text labels overlap with chart elements

Increase the doughnut hole size (up to 80%) or position text boxes outside the chart area using Insert > Text Box with manual placement.

Colors don't display as intended

Right-click each data series segment individually, select Format Data Point, and manually assign colors under Fill > Solid Fill instead of relying on chart themes.

Related Excel Formulas

=MAX()=MIN()=IF()=IFERROR()

Frequently Asked Questions

Can I create a speedometer with multiple needles or ranges?

Yes, you can layer multiple doughnut charts on top of each other with different data ranges and color zones to show multiple metrics or risk levels.

Is there a faster way to create speedometers in Excel?

Use Excel's built-in Gauge chart type in Excel 2016 and later (Insert > Charts > More Charts > Gauge), which automatically formats as a speedometer.

How do I make the speedometer chart responsive to dashboard filters?

Use slicers connected to your data table, then link your speedometer chart to the filtered data range via Data > Slicers, ensuring dynamic updates.