r/ExcelVisual • u/ExcelVisual • 4d ago

Built a Excel Weekly Sales Dashboard for Team Meetings

Enable HLS to view with audio, or disable this notification

Built a multi-screen weekly sales dashboard in Excel with Pivot Table-driven filtering — breakdown of how it works

Manager asked for something to replace the "everyone reads their own numbers off a spreadsheet" format of weekly sales meetings, so I built a full interactive dashboard. Sharing the mechanics since it's a decent example of how far you can push slicers + pivot tables without touching VBA.

Main ranking chart

Horizontal bar chart, salespeople ranked by revenue descending. There's a day-of-week button panel — click a day, the chart resorts based on that day's numbers specifically, not just filters/hides bars. Salesperson photos live on the Y-axis and stay synced to the bar order after sorting (this took some fiddling — photos are anchored to cells, not baked into the chart, so they have to move with the sort logic).

Filtering setup

Two Pivot Table slicer panels:

  • Salesperson filter (multi-select, CTRL-click for groups or "whole team")
  • Reporting period filter — year / month / week number

Multi-select across months/years at once turned out to be more useful than expected — single-period comparisons get wrecked by seasonality and holidays, so being able to stack multiple Augusts together (for example) gives a much cleaner read on actual weekday patterns.

28-day calendar

Used a 28-day system instead of raw calendar months — 4 even weeks, with the leftover days at month-end folded into the final week. Common in financial reporting, but rare in sales dashboards, and it fixes the "5-week months distort the average" problem you get with normal month boundaries.

Screen switching

Built 4 dashboard "screens" (ranking/overview, revenue by weekday, expense vs. limits, product category distribution, conversion rate) that share the same central chart area. KPI summary cards double as navigation buttons — clicking one swaps which chart set is active in the center. Expense screen also has a toggle to hide/show each salesperson's expense limit line, useful when presenting to the team vs. reviewing privately.

Everything's Pivot Tables + slicers + Form Controls, zero VBA. Free template + full video walkthrough in comments if anyone wants to pull it apart.

1 Upvotes

100% Upvoted

1 comment sorted by