Smart Dashboard Ranking Tables

Chandoo and Robert over at the PHD blog have a nice a 4 post series of posts about Creating KPI Dashboards in Microsoft Excel.

• Show only 10 items of a huge list, but give the user the chance to scroll down without having to go to the list of raw data.
• Let the user choose how the list is sorted (Adding One Click Sort)
• Add further value by brushing the data
• Improve visualization by adding meaningful bar charts directly into the table

I really recommend you to read Robert’s articles. Having scrolling in your sorted table is just a really smart addition to your Excel dashboard.

Yesterdays post was about Adding One Click Sort:

I knew that Robert would show how to add bar charts in a later article, but I couldn’t resist the temptation to pick up Robert’s workbook and to add some Micro Bar Charts.

I opened Roberts workbook, added some columns for my bars, and inserted a Micro Bar Chart:

The I defined colors for the positive and negative bars:

And defined the appropriate number format string of our KPI thick mark labels:

And you are done !

‍