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 ...
- MIS Cockpit Enterprise Dashboard - Putting Excel on steroids with Palo, an open source business intelligence tool ...
- SharePoint Dashboard Conditional Indicators ...
- Secret Salesforce Management Dashboard ...
- Office 2007 Dashboard - Review of Excel 12 as a tool for dashboards ...
- 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?
- Hospital Financial Management Dashboard
- Restaurant Performance Dashboard
- Business Intelligence Architectural Stack
- 3 Steps for Performance Improvement
- More on the Pie Chart
- Dell IdeaStorm Dashboard
- Excel Tool Tips
- Rube Goldberg Dashboard
- Dashboard Spy White Paper Collection Launches
- Excel Visualization of Olympic Medal Count


