![]() If you don’t want to build a spreadsheet from scratch, you can download a template like the one above and enter your data. I have recently updated this dashboard to include a few new elements, an additional chart and I have streamlined the colour scheme.Now that we’ve looked at a great example and taken note of the key elements, it’s time to see how to make our own. It was enjoyable putting together this Excel dashboard, I did not win but I did get a page dedicated to this dashboard on There were 119 entries in the dashboard competition. The competition was open to all with a first prize of an iphone 6. The Team Performance Dashboard is a dashboard I created as a submission to the Excel Forum Dashboard competition in November 2014. The input sheet acts as the control tab where data is entered into the back end database. People are added to schools on the staff sheet. I will leave the coding in the worksheet in case people find this useful. There is some coding behind the sheet but this is only to speed up the data input. The dashboard shows data by discipline and shows the trends on spend over a one year period. It is an Excel 2010 workbook which uses a slicer to flick the dashboard between schools to show performance. The School Excel Dashboard is a dashboard which shows plan v actual for a number of schools across disciplines. The dashboards are all a little different, some spin on combo boxes, option buttons, slicers and there is a few that changed based on the mouse rolling over a cell or two. All have an associated Excel dashboard template which is fully functional and has a complete data set inside it. The next section contains a selection of the Excel dashboards on this site. An Excel file is on every page with a brief description of the Dashboard. Click on the link or picture to visit the specific Excel dashboard page. I will be creating more and more Excel dashboards and these dashboards will be free to download. The following are the sites current Excel dashboards to download. There are a couple of exceptions when you get down to the Heat Map section but mostly native Excel run these dashboards. On the whole these Excel Dashboards do not need VBA at all. Many of the techniques spoken about in the site which I have incorporated on are built into these Excel dashboards. I then just needed to sketch out a final output dashboard and work backwards to make the data fit that vision. Later I got a bit smarter and found that wiki and some government websites had ready made tables which were Excel compatible. I would scratch my head as I started creating the raw data from scratch early on. One of the issues with developing the following Excel dashboards is obtaining the data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |