Smart Dashboard Ranking Tables

Published on
August 24, 2008

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

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:

image

The I defined colors for the positive and negative bars:

image


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

image

And you are done !

image

Gary Crawford
COO, XLCubed
Fluence Technologies

Connect with Fluence

Discover how Fluence can help your organization plan better and close faster with more confidence.