National Excel Dashboard

This heat map Excel dashboard has a heat map of Australia which changes according to the selection made in the drop down.  The dashboard displays key metrics from Australia such as the split of the GST between States and Territories, key export markets and trade partners.  The dashboard has a slicer at the bottom which allows different selections, the flags next to the slicer will change based on the selection.  The technique for this can be found on the Toggle Chart page.  The dashboard will work on Excel 2010 and later.  

 

Excel Dashboard Australia

 

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

Smallman Dashboards

The following file is a macro enabled workbook and my web provided only allows xls or xlsx workbooks.  The Excel dashboard and its supporting data should be easy to follow.