A Quick Dashboard in Excel is a very attractive, informative and small dashboard which has been designed by me and my team. By this dashboard, we want to showcase how can you show your small data set with the visuals. We have not used any VBA to create this dashboard.
This Excel dashboard has been designed for month on month Service Level, Quality Score and Productivity metrics or any other metric.
In this dashboard we have created 3 Waffle chart for Service Level, Quality Score and Productivity which change on the base a Form Control Combo box.
In the bottom section, we have displayed a Line Chart which change on the of Form Control Option buttons.
Click here to download this Excel dashboard file.
Watch the step by step tutorial for this Quick Dashboard: