Happy Face Excel Dashboard - using conditional graphics to show KPI status
On the lighter side of enterprise dashboard design, we look at this nifty excel dashboard example using graphics to show status or state. From the excellent excel resource site, www.contextures.com comes this great xls file download of a happy face excel dashboard. The idea is that this sample shows how an excel graphic changes in response to the entry of a different cell value. I grabbed 2 screenshots below. The first value is 95 which gives me the bright happy smile. The second worksheet shows a much lower value and hence we get the frowny face. Maybe something gimicky to lighten the day the next time you deliver an excel spreadsheet to your users? Finally KPIs that smile or frown at you!


Homework: If you need to catch up on some excel charting basics, start with 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_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.
Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.
What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- Security Update Patch Management Dashboard for Monitoring Patch Status ...
- Building an Executive Dashboard in Excel 2007 with Conditional Formatting ...
- The Future of Excel Dashboards ...
- SharePoint Dashboard Conditional Indicators ...
- MIS Cockpit Enterprise Dashboard - Putting Excel on steroids with Palo, an open source business intelligence tool ...
- Office 2007 Dashboard - Review of Excel 12 as a tool for dashboards ...
- Secret Salesforce Management Dashboard ...
- A Look at Building Dashboards in Excel ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Project Gemini and Excel Dashboards
- Bling My Dashboard
- Direct Marketing Metrics Dashboard
- Pop-Up Dashboard for 2008 Election Results
- Synchronized Presidential Debates Dashboard-Style
- 2008 Political Dashboards for the Election Home Stretch
- Intranets, Portals and Dashboards, Oh My!
- Real Time Excel Dashboard Tracks Gas Prices
- CERN Collider Dashboard
- Dashboards As Navigation


