Team Performance Dashboard - contains excellent charts

Created by: Small_man

About Dashboard:

This dashboard shows the team’s performance on the basis of team members, product, region and time.

The dashboard contains 3 interactive data tables, 8 interactive charts and 1 static chart to display the management information.

The main objective of this dashboard is to provide key information in one place and see how it is tracking against the key criterions, like performance by region, revenue by team, sales by team, sales by product, revenue by product, etc.

The team’s performance uniquely measures both soft and hard performance factors and helps to drive continuous and curative parameters.

There are many ways in which you can visualize team’s performance data to understand the achievements by various teams. In the month of October, Excel Forum team has launched a dashboard competing in which you are asked to visualize team’s performance data using sample data. The challenge has generated a huge thrill around the community and has fetched 118 incredible entries.

Thanks everyone for participating and making ita huge learning experience for everyone. Excel Forum team has learned several useful dashboard and charting tricks.

In this article, we will show you the steps to create this dashboard.
Let us see the how Dashboard made by Smallman looks:
We have divided this dashboard into 5 sections of information. Let us take a look at each one separately.


This section is the heart of this dashboard by Smallman. The slicer technique is used to filter all the regions individually; the viewerneeds to select the region & all the related information will be updated dynamically.
Section 2:

In this section, we will take a look at left portion of the dashboard screen that is displaying details of team performance by revenue, revenue per hour, sales & sales per hour.
Section 3:

This section highlights team login hours, talk time, hold time & inactive %.
Section 4:

This section covers team calls, positive, negative & all feedback.
Section 5:

This section provides the revenue-related information for all or selected regions.
Section 7:

This section provides login hours by region & team wise.

This section focuses on talk time information by region & team wise.

In this section, feedback for team performance, whether positive or negative, is shown region wise.

This section highlights sales data by region, for all the teams.
Section 11:

The last section covers the right portion of the dashboard screen, which highlights sales by product, revenue by product for all regions & revenue generated in % by all products.
Using this dashboard,we can get a clear view of the Team Performance,and we can get the information from various points of view.

Download Dashboard


  1. Hi, i liked your dashboard.

    I'm novice in this type of area.

    Can you please help how you put the transparent picture on top of tables. Do you insert it from external website or is there a quicker way to put it on the table?

    Thank you in advance

    • Hi Zak

      Sorry for the very late reply. The transparent picture over the top of the text is just for effect. It can be achieved by creating a Text Box, then changing the colour of the text box (grey in my case) and changing the transparency of the text box to say 60%.

      I hope that helps you or someone following this post in future.

      Take care


  2. You guys really went to a lot of effort to describe every segment of this dashboard. You have a very large task doing this for 118 dashboards. The effort will be worthwhile and this dashboard section will be a great reasource for the Excel community.

    Thank you


Leave a Reply to Andy D Cancel reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.