Display Alerts in Dashboards to Grab User Attention [Quick Tip]
Dashboards can be overwhelming with lots of details and context. A simple way to drag user’s attention to important stuff in the dashboard is to use alerts. See this example to understand what alerts mean.
How to display alerts in Excel Dashboards?
The easiest way to display alerts is to use Excel 2007’s Conditional Formatting feature – Icon sets.
Assuming you have a table in dashboard like above (data),
- Select the alert column and go to Conditional Formatting > Icon sets > 3 Traffic Lights (unrimmed)
- Now, go to Conditional Formatting > Edit Rules
- check “Icons in reverse order” and “Show icons only” buttons and you are done!
- Add an extra column next to Alert column.
- Here type the formula
=IF(C1,CHAR(152),"")[assumes column C has alert data]
- Select the column and set its font to “Wingdings 2” and color to Red. The Char code 152 is a big black circle in wingdings 2 font.
Do you use Alerts in Dashboards?
I think alerts add richness to dashboards and prompt users to take action. But too many alerts can be distracting. I have used alerts by showing red color dots or circles in dashboards to draw my manager’s attention to certain points.
What about you? Do you use alerts in dashboards? How do you automate them? What technique do you use? Share your ideas and tips using comments.
More resources on Excel Dashboards:
- KPI Dashboards in Excel – 6 part tutorial
- Dynamic Dashboards in Excel – 4 part tutorial
- More Dashboard tips, resources, templates
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« An Excel Hero indeed [blog recommendation]||Dynamic Dashboard in Excel – Pulling it all together [Part 4 of 4] »|