Tennis Dashboard in Excel

Who was better? Federer or Djokovic.. Nadal or Murray

ATP uses following Dashboard to compare statistics between the players

Although such a dashboard may not be the ideal way of  comparing the statistics, nevertheless it is quite useful to compare many items/Stats/Features across 2 categories (Products,Players etc).

I have reproduced this Dashboard in Excel using certain techniques which I will explain in ensuing paragraphs. You can use this IDEA for example to compare 2 PRODUCTS, ENTITIES etc

Click here to Download Tennis Dashboard

 

TRICKS and TECHNIQUES USED

Following steps are used to create this dashboard

1.Insert pictures of the Players in Excel. Place them inside cells (You can do it manually. Also you can use my “Image Inside Cells” Add-In.

2. Name each of the above Cells by Player’s Name. In above picture, you can see Cell A1 selected and name box showing “Djokovic”

3. Create 2 linked pictures by copying one of the above cells and pasting them as Linked Pictures in the “Dashboard” sheet

4.Insert two spin buttons in Dashboard (Form Controls in “Developer” Tab)

5.Create Dynamic Named Ranges “Player1” and “Player2”

Player1=CHOOSE(Ref_player1,Djokovic,Federer,Murray,Nadal,Thiem)

Player2=CHOOSE(Ref_player2,Djokovic,Federer,Murray,Nadal,Thiem)

Ref_player1 and Ref_player2 represent Cell Links of the 2 Spin Buttons you inserted above

6. Change the formula of linked pictures to =Player1 and =Player2

7. Use the REPT(“|”,) function and STENCIL font to emulate data bars

PRACTICAL APPLICATION

This Dashboard technique is quite useful when you have to compare many items across 2 Categories

You can use the above idea for example to create a HEAD 2 HEAD Dashboard comparing PRODUCTS, CUSTOMERs or ENTITIES

Following picture shows how I used this idea in one of my Dashboards.

 

 

Share This: