Traffic Light Excel Dashboard
In Excel you can create dashboards using a traffic light technique. The following article takes you through how to create an Excel dashboard with traffic lights. The Excel dashboard uses generic organisational data to display actual V plan data and shows EBIT, Revenue and Expenses graphically at the side. In the dashboard there is a traffic light effect to indicate progress against plan for each of the teams and a combo box to choose which area's financials you want to see. It was the first Excel Dashboard report I created for the Smallman.com!!! In early 2017 I update the dashboard to add addional functions and information. Enjoy.
For a listing of all Excel Dashboards on the Smallman.com visit this link. There are more Excel files than you will be able to view!! Many different Excel dashboards to choose from with a range of different metrics. However, the sample should give you insight into what is possible with Excel. Excel dashboard creation should be fun and creative, be consistent with your colours, try to align elements of your dashboard, group like items together to ensure flow and get others involved in the process. Group think always produces a more informed outcome.
I am starting a YouTube channel to demonstrate some of the visual aspects on TheSmallman.com and to outline automation. My page can be found here. Smallman on YouTube
The following Excel dashboard outlines the above. The Excel file should be very easily adapted to your needs. Change some of the drivers and the conditional formatting to suit.
