How to Build an Excel Dashboard: Sales Charts and a Speedometer KPI Gauge
Most businesses are sitting on a spreadsheet full of numbers that nobody outside of accounting ever really looks at. The data is there: sales by month, performance against goal, revenue by rep, but it’s locked in rows and columns that make your eyes glaze over. The job of a dashboard is to fix that: to take those raw numbers and turn them into a picture your leadership team can read at a glance and act on in seconds.
The good news is you don’t need expensive business-intelligence software to get there. Excel, which you almost certainly already have as part of Microsoft 365, can build clean, presentation-ready charts and even eye-catching KPI gauges. In this guide we’ll walk through two of the most useful visuals you can add to a sales dashboard: a column (bar) chart that shows performance over time, and a “speedometer” gauge that shows progress toward a goal. Each section includes a short video walkthrough plus a plain-English explanation so you can follow along in your own workbook.
Build a Sales Column (Bar) Chart in Excel
A column chart is the workhorse of any sales dashboard. It’s the fastest way to answer the questions leadership asks most: Are we up or down? Which month was strongest? Are we trending the right direction? Bars give the eye an instant sense of scale that a table of numbers never will.
How it works
Start with a simple two-column layout: your labels in one column (months, reps, or product lines) and the matching sales figures next to them. Highlight that range, head to the Insert tab, and pick a Clustered Column chart. Excel drops a basic chart onto the sheet immediately. From there it’s all cleanup, and that cleanup is what separates a chart that looks like a default and one that looks like it belongs in a board deck.
The video walks through the polish: giving the chart a clear title, removing the gridlines and clutter that compete for attention, adding data labels so the exact numbers sit right on the bars, and choosing colors that match your brand instead of Excel’s stock blue. A couple of small touches: a consistent color, a clean title, labels on the bars. Those are the difference between a chart people skim past and one they actually read.
Build a Sales Speedometer (Gauge) KPI Chart in Excel
A speedometer, or gauge, chart is the one that makes people lean in. It shows a single number against a goal the same way a car’s dashboard shows your speed against the limit, with a needle sweeping from empty to full. It’s perfect for the “are we hitting target?” question, because anyone can read it in half a second without knowing a thing about your spreadsheet.
How it works
Excel doesn’t have a built-in gauge, so this one is a clever trick: you combine two doughnut charts (or a doughnut and a pie) stacked on top of each other. The bottom doughnut becomes the colored arc (the dial face, often split into red, yellow, and green zones), and a thin pie chart on top provides the needle that points to your current value. Hiding the right slices and rotating the chart is what turns two ordinary charts into something that looks like a real instrument panel.
The video takes you through it piece by piece: setting up the helper table that feeds the dial zones, building and layering the two charts, making the needle slice transparent everywhere except the pointer, and rotating everything so the gauge sweeps across the bottom half like a true speedometer. It takes a few more steps than a column chart, but once it’s built you can point the needle at any KPI, revenue to goal, tickets closed, project completion, just by changing one cell.
Excel Dashboard Best Practices
Two great charts don’t automatically make a great dashboard. How you assemble and present them matters just as much as how you build them. A few principles keep your dashboard useful instead of cluttered:
- Lead with the one number that matters. Put your most important KPI (the speedometer, usually) top-left, where the eye lands first. Supporting detail goes below and to the right.
- Cut the clutter. Strip out gridlines, chart borders, and legends you don’t need. White space is a feature, not wasted room. If a pixel isn’t helping someone make a decision, remove it.
- Stay consistent with color. Pick two or three brand colors and use them the same way everywhere: green always means “good,” red always means “behind.” Random rainbow charts make people work harder than they should.
- Connect everything to live data. Build your charts off a clean data table (or a PivotTable) so the whole dashboard refreshes when you paste in next month’s numbers. A dashboard you have to rebuild by hand every month won’t survive past month two.
- Design for the screen it lives on. If leadership reviews it on a laptop or a wall-mounted TV, size it to fit without scrolling. A dashboard nobody can read at a glance isn’t a dashboard.
Keep those in mind and your charts stop being decoration and start being a tool your team checks every morning.
Let AI Do the Heavy Lifting
Here’s where things have changed fast. You no longer have to guess which chart fits your data or fumble through the doughnut-chart gymnastics for a gauge. AI assistants like Microsoft Copilot, Claude, and ChatGPT can look at your sales data and tell you which chart type tells the story best. Copilot, built right into Excel, can build the chart, write the formulas, and even draft a whole dashboard layout from a plain-English request like “show me sales by month against goal.”
The trick is knowing how to ask. A vague prompt gets a vague chart; a clear one gets exactly what you pictured. Our Claude AI Cheat Sheet walks through how to write prompts that get useful, accurate results the first time, so the AI saves you time instead of sending you in circles.
Frequently Asked Questions
How do I make a dashboard in Excel?
Start with a clean data table, build the individual charts you need (a column chart for trends, a gauge for goal progress, a few summary numbers), then arrange them together on a single worksheet. Put your most important KPI top-left, keep your colors consistent, and connect every chart to the same source data so the whole thing refreshes when you update your numbers. The two videos above cover the chart-building piece; the best-practices section covers how to assemble them into a dashboard.
How do I create a speedometer or gauge chart in Excel?
Excel has no built-in gauge, so you create one by layering two charts: a doughnut chart for the colored dial and a thin pie chart on top for the needle. You hide the slices you don’t want, make the needle slice transparent except for the pointer, and rotate the whole thing so it sweeps across the bottom like a speedometer. The video in the speedometer section walks through every step.
What’s the difference between a column chart and a bar chart?
They’re the same idea, just oriented differently. A column chart shows vertical bars (good for showing change over time, like months across the bottom), while a bar chart shows horizontal bars (handy when you have long category labels or are ranking items). Excel lists both under the same chart menu, so you can switch between them with one click.
Can AI build Excel charts for me?
Yes. Microsoft Copilot is built into Excel and can create charts, write formulas, and lay out dashboards from a plain-English request. Tools like Claude and ChatGPT can also recommend the right chart type for your data and explain exactly how to build it. The key is a clear, specific prompt. Our Claude AI Cheat Sheet shows you how to write one.
Want AI and Automation Working Inside Your Business?
Charts and dashboards are just the start. The real win is when AI and automation are wired into how your business actually runs: pulling your data together, surfacing the numbers that matter, and handling the busywork so your team can focus on the work that grows the company.
That’s what we help Houston businesses do. If you’d like to see what AI and automation could look like inside your operation, book a free discovery call or give us a call at 281-367-8253.
Keep the shortcuts handy: grab the free Excel keyboard shortcuts cheat sheet, printable as a one-page PDF.
More Excel guides: VLOOKUP, XLOOKUP and INDEX/MATCH · IF and COUNTIF formulas · Data validation and dropdowns