For business users of Microsoft Excel Free guides and templates

Excel Dashboards

A Monthly Financial Dashboard that Combines Standard Tables & Charts

You can give your managers and clients financial information in a report that's more informative and easier to read than they've ever seen before.

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

This report combines traditional tables of financial information with charts of financial measures. I created it to replace the ugly, hard-to-read financial reports that I had created for decades.

Of course, Montana Office Products doesn't exist (as far as I know) and the data is completely artificial.

Dashboard Reporting With Excel explains the general technique for creating reports like this. And you can get this these dashboards here.

Excel dashboard of monthly financials, using a custom color theme

Excel dashboard of financial data using a gray-scale custom color theme

Free Excel Dashboards

Click to see testimonials from readers

Charley's SwipeFile charts

Click to see who uses Excel dashboards.