Top-Bottom Analysis in Excel
Charts and Visualization Dashboard

Top/Bottom Analysis dashboard in Excel

In this article, we have created Top/Bottom Analysis dashboard using a sales dataset. This is a dynamic dashboard. We have used Slicers, Form control Option buttons and form control Scrollbar to make it dynamic.

We have used below given sales data to create this dashboard-

Sales Data
Sales Data

Using the Top/Bottom option button, you can display the Top or bottom employees and locations. You can use the scroll bar to change the number of employees and locations.

Top/Bottom Analysis
Top/Bottom Analysis

Watch the step by step video tutorial :

Click here to download the practice file.

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.