Excel Tool Tips
A Dashboard Spy reader wrote me to ask about adding comments to his Excel worksheets so that his users would be prompted to take certain input actions. He’s building a series of excel dashboards complete with data input screens.
I directed him to Michael Alexander’s latest Excel Tip: Adding Tool Tips to Cells, a quick but excellent video tutorial on how to achieve a tool tip effect such as you see below:

The tool tip is easy to implement in Excel. Don’t use a “comment” - see video to see why. Instead, use Data Validation/Input Message. Simply click on a cell, go to Data, then Data Validation. On the Settings tab, under validation criteria, choose Allow Any Value. Then go to the Input Message text box and enter your tool tip.
View the video to see how simple this is.
Michael Alexander of DataPigTechnologies.com is the author of Excel 2007 Dashboards & Reports For Dummies
Also, be sure to catch his video on Creating Bullet Charts in Excel.
Tags: Excel techniques for Business Intelligence 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:
- A dashboard-type management console plus 23 UI tips ...
- Excel Visualization of Olympic Medal Count ...
- Excel-based Enterprise Dashboard - excel worksheet xls file download ...
- The Future of Excel Dashboards ...
- Excel Dashboard for Monitoring the Competitive Landscape ...
- Building an Executive Dashboard in Excel 2007 with Conditional Formatting ...
- KPI User Requirements for Dashboard Projects - Using the KPI Wheel, a Flex Dashboarding Tool ...
- Web Measurement KPIs - Choosing the best metrics for web analytics enterprise dashboards ...
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


