Sales Person Dashboard
The Sales Person Excel Dashboard is a dashboard which traps sales person data by State based on Australian States. There is quite a bit of information on the Excel dashboard. The dashboard has 5 static charts to show the overall sales position and 20 dynamic charts which are based on the slicer at the top of the dashboard which spins on year. Apologies to Tasmania and the Territories for the no show on this dashboard.
The above dashboard runs off a slicer, so at least Excel 2010 is required to see its functionality. There are 25 dynamic charts and 5 static charts in the dashboard. The charts on the far left by state are static but every other chart updates in conjunction with the slicer.
The following Excel Dashboard is added to show workings.