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!!
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 condional formatting to suit.