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.

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 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.
https://www.pk-anexcelexpert.com