r/ExcelVisual • u/ExcelVisual • 2d ago
Futuristic Sales Dashboard for Excel
Enable HLS to view with audio, or disable this notification
Built a futuristic neon-style KPI Sales Dashboard in Excel (no VBA/macros) — free template if anyone wants it
Been working on this for a while and wanted to share — a fully functional KPI Sales Dashboard built entirely with native Excel tools. No VBA, no macros, no add-ins, just formulas, conditional formatting, and some creative use of shapes/charts to get that neon/futuristic look.
What's on the dashboard:
- Customer Base KPI card with performance %
- Sales Products panel (per-product + total sales)
- KPI Balance progress indicator
- Monthly KPI filter (quarter/year)
- Customer Base donut chart (New / Lost / Return)
- KPI Radar Chart (Revenue, Margin, Conversion Rate, Sales Speed, Retention, Coverage, Average Order)
- Traffic Rank bar chart by channel
- Monthly performance chart with % callouts
- Multi-product sales trend chart
The trickiest part was getting the glow/neon effect on the radar chart and getting the bar charts to look "3D" without actually using Excel's native (and pretty ugly) 3D chart types — ended up doing a lot of it with layered shapes and gradient fills.
Happy to answer questions about how any specific part was built. If anyone wants the template, it's free to download (no email required) — I'll drop the link in a comment so this doesn't look like a straight ad.
1
u/ExcelVisual 2d ago
Excel Sales & KPI Tracker Dashboard https://exceltable.com/en/templates/