How to Create a Gauge Chart in Excel - Practical Guide

You'll learn to create a gauge chart in Excel, a circular visualization that displays progress toward a target or goal. Gauge charts are ideal for KPIs, performance metrics, and status dashboards, making data interpretation intuitive and visually compelling for stakeholders and executives.

Why This Matters

Gauge charts instantly communicate performance status and progress, making them essential for dashboards, reports, and presentations. They provide immediate visual feedback without requiring detailed data analysis.

Prerequisites

•Basic Excel knowledge and familiarity with data entry
•Understanding of chart types and Insert menu navigation
•Data prepared with a value, maximum target, and minimum baseline

Step-by-Step Instructions

Prepare your data

Create three cells with values: current value (e.g., 75), minimum (0), and maximum target (100). Arrange them in a single row or column for easy reference.

Select the data range

Highlight the three cells containing your current value, minimum, and maximum. Go to Insert > Charts > Pie Chart (or Doughnut Chart as alternative).

Choose chart type

Select Doughnut chart type, as Excel doesn't have native gauge charts. Right-click the chart and choose Select Data to customize which values display as segments.

Format as gauge chart

Delete or hide the data labels you don't need. Right-click the doughnut ring, select Format Data Series, and adjust the Angle of first slice to 270° to create gauge orientation.

Customize appearance and add labels

Format colors to represent zones (green for good, yellow for caution, red for warning). Add a text box with the percentage/value inside the center, then adjust legend and title as needed.

Alternative Methods

Use combo chart with secondary axis

Create a pie chart combined with a line chart on secondary axis to simulate gauge appearance. This offers more control but requires advanced chart editing.

Third-party add-ins

Download Excel add-ins like Mekko Graphics or Power Map that include built-in gauge chart templates for faster creation and professional styling.

Tips & Tricks

✓Use contrasting colors (red-yellow-green) for instant visual impact and intuitive status recognition.
✓Place the gauge chart on a separate area of your dashboard for prominence and clarity without cluttering data.
✓Update data dynamically by linking cells to formulas instead of static values for real-time gauge updates.

Pro Tips

★Add conditional formatting to your value cell to automatically highlight performance status, reinforcing the gauge visualization.
★Create multiple gauge charts in series for comparative dashboards showing performance across departments or time periods.
★Use data validation dropdowns to switch between different metrics without rebuilding the entire gauge structure.

Troubleshooting

Gauge chart appears as standard pie chart without gauge orientation

Right-click the chart data series, select Format Data Series, locate the Angle option, and change it to 270 degrees. Ensure your doughnut type is selected, not pie.

Data labels overlap or are difficult to read

Delete auto-generated labels and insert a text box manually in the center with your value. Format the text box with larger font and contrasting background color.

Colors don't display correctly or segments are invisible

Check that your data values are numeric and positive. Select each data series segment individually and apply fill color manually via Format Data Point.

Related Excel Formulas

IF MIN MAX SUM

Frequently Asked Questions

Does Excel have a native gauge chart type?

No, Excel doesn't include a native gauge chart. You create gauges using doughnut or pie charts formatted with specific angles and colors. Third-party add-ins offer true gauge templates.

Can I make the gauge chart update automatically with live data?

Yes, link your data cells to formulas or external data sources instead of static values. The gauge will refresh automatically whenever source data changes.

How do I create multiple zones (red, yellow, green) in a gauge?

Divide your maximum value into segments representing each zone. For example, 0-33 red, 34-66 yellow, 67-100 green, then format each segment with corresponding colors.