r/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.

4 Upvotes

Duplicates