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 in the top right corner, which controls all of the calculations that run from clicking the slicer. It in turn changes a pivot table where the data changes. 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.
