The Dashboard Spy

June 5, 2006

Excel Enterprise Dashboard Download – worksheet with small business KPI charts

Filed under: Dashboard Screenshots — dashboardspy @ 9:22 am

Dashboard Spy reader updates:

See latest examples of Small Business Dashboards.

And be sure to check these Excel Templates for Dashboard Reports.

The recent focus in this dashboarding forum on Excel dashboards has prompted Dashboard Spy emails with links to their favorite enterprise dashboard worksheets. Lynn points us towards this Excel business dashboard. It’s a downloadable xls file. As you can see from these dashboard screenshots, there is a data input page and lots of nicely laid out charts. Try it out and compare it to the other Excel-based spreadsheets we’ve been pointing to. This one has a good set of business KPIs that are particularly helpful to small businesses.

Executive KPIs include:

Sales by Product
Total Sales
Total Sales Budget Over/Under
Cost of Goods Sold
Operating Expenses
G&A Expenses
Payroll Salaries
Sales Expenses
Marketing Expenses
Research & Development Expenses
Interest income (expense)
Other income (expense)
Total Nonoperating Income (expense)
Income (Loss) Before Taxes
Income Taxes
Net Income (Loss)
Cumulative Net Income (Loss)

Enterprise Dashboard

Executive Dashboard

Homework: Don’t feel bad if you need to review the basics of graphing using Microsoft Excel. Start with these books on excel charts. A good excel charting basics books is Excel Charts for Dummies

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ Also check out The Dashboard Spy’s favorite books.


  1. […] Excel Dashboards The Dashboard Spy has been reporting on how people are using Excel to provide nice looking dashboards that help them keep their businesses smoothly.   […]

    Pingback by Magnum B.I. : Excel Dashboards — June 7, 2006 @ 8:45 am

  2. Excel for dashboard style displays. This is great. Thanks. I’ve been trying to create excel dashboards. Go Dashboard Spy!

    Comment by Excel Dashboarder — June 16, 2006 @ 7:48 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: