Investment Portfolio Rankings De-cluttered

At my work we track and rank various statistics across more than 200 investment portfolios. One of the managers with 2 portfolios, used to be ranked in the top quartile for a certain statistic, but I noticed recently that they are now only top-half. To better understand what happened, I grabbed all of the portfolio rankings over time and plotted them in a single line-chart - If you are familiar with soccer, then think League-chart or rankings-chart. With so many lines, I basically ended up with a noisy plot that made little sense. What I realized though is that by selecting Excel's gray color palette, I could blend together all of the uninteresting portfolios and then thicken and color the two in which I was interested. I like how all of the background noise becomes something of a wall paper that you don't see.

There was one other trick. I needed to raise the two highlighted data series to the top of all of the other lines, and that was slow to do using the 'data series' selection box arrows. I ended up rearranging my underlying data columns of data to get the same effect. The rightmost columns of data in Excel were the top-placed lines on the graph.

Takeaways:

1) I didn't actually use this chart in my eventual writeup. I simply used to to figure out that something happened in Feb-Mar 2011, and so I dug into investor reports from these two dates for these funds and wrote down what happened. In that sense it was an exploratory graphic versus a story-telling one. The actually story of what happened in the portfolio is more important than the rankings.

2) I don't think this could ever end up in marketing materials - a league rankings type of chart is pretty difficult to explain and is an extra step removed from the underlying data. There are much simpler ways to show that something happened in Feb-Mar 2011.

3) That said, I do think the gray palette combined with highlighting certain data series is a great way to de-clutter a noisy graph, especially since it only took 2-3 minutes in Excel. I'd love to find a more practical use for it in the future.

Visualization in the Kitchen

We recently renovated our kitchen. We thought it would be simple because there weren't any existing cabinets and we weren't moving any walls, but boy were we wrong! One thing that did help out a lot though was our data visualization tool, Google Sketchup. Sketchup is a beautiful and free-to-use tool and after spending a solid weekend with it, maybe 20hrs, I had a great model that my wife and I used to tweak our design. We uncovered many flaws in our initial ideas that just wouldn't look good or wouldn't even work. Google Sketchup was invaluable and saved us many troubles and hassles. It also helped us to negotiate with and explain our design to contractors, prior to them bidding.

Here are a few renderings of our final model:

Once we created this model, ordering cabinets was a snap because most of the details and dimensions were already figured out. We worked with somebody from Lowe's who offered some great suggestions; for instance he suggested swapping the fridge and the pantry so that the fridge would be easy to load and unload next to the counter. He also knew much more about cabinet door clearances and spacing than I.

It wasn't so easy to take pictures of the final work because you can't do a cut-away or an overhead shot, but here are some photos. I'll let you decide for yourself how close we were to the model, but we are very happy with the results: