England Heat Map Excel Dashboard

This Excel dashboard will change the colour of each of the regions in England dependent on the value selected in the combo box next to the map of England.  The regions are as follows;

The Heat Map gives three choices in the combo box besides the Map, population, Employment and Income and each has its own colour scheme.

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!! 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.

Smallman Dashboards

The charts on the right bottom of the dashboard are linked to a combo box which isolates life expectancy by region.  A description of this method can be found at Heat Map in Excel.  

The following is the file which contains the above excel heat map dashboard with its supporting data.