Creating KPI Dashboards in Microsoft Excel [Part 2 or 4] - Adding One Click Sort

Creating KPI Dashboards in Microsoft Excel is a series of 4 posts by Robert from Munich, Germany.
Read part 1 of this series, Creating Key Performance Indicator Dashboards in Excel with Scroll Controls before reading this post.

The Challenge - Sorting
With the post KPI Dashboard Table – Scroll we started a little series of posts on [...]

Creating KPI Dashboards in Microsoft Excel [Part 1 of 4]

Creating KPI Dashboards in Microsoft Excel is a series of 4 posts by Robert from Munich, Germany. Robert has been using excel for last 18 years starting with MS Excel version 3.0 in 1990. He has huge passion for data visualization and presentation using excel. When I got a mail from him 2 weeks back [...]

Bingo / Housie Ticket Generator in Excel

I am fascinated by board games. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money. That is why whenever I get sometime I experiment with simulating games to know them better [read Why Monopoly board game is not as random as it appears]. [...]

Incell Bar charts - Revisited

I can never get tired of in-cell charts, whenever I get sometime, I try to experiment something on them. Here is an idea to design true incell column charts without using any add-ins or installing fonts. These charts can be fun to have on your project report or annual news letter or memos, they take [...]

Use Google docs to track your bucks - [spreadsheet forms idea]

Each of us have our mechanisms to track how we spend money. We use Excel, various online sites and software like Quicken or Microsoft Money to track how we spend our bucks. The bottom line is to track where each penny / paisa / cent is going. So, how great would be it be, if [...]

Partition Charts - Continuation - [More visualization fun]

Jon @ Peltiertech has taken a critical look at the partition charts suggested yesterday. You can read his review of the partition charts here. One of the commenters on his site said,
Jon, the partition chart is not that bad. It just needs to be defragmented…
So I de-fragmented my partition chart, this time it [...]

Partition Charts in Excel - alternative to pie charts [visualization hack]

Next time you had to create a pie chart, consider building a partition chart as these charts can reveal trend information along with how much each pie is contributing. What more? They are as easy to create as eating a chocolate chip cookie dough ice cream
I made a sample partition chart based on [...]