Category Archives: Excel Tricks

Smart Dashboard Ranking Tables

Posted on August 28, 2008 by XLCubedBlog

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 … Continue reading →

Posted in Dashboard, Excel Tricks | Leave a comment

Heatmap Tables with Excel

Posted on August 24, 2008 by XLCubedBlog

This Heatmap Table shows you the revenues and the discounts of a company over the course of one year per product group. The size of a bubble shows the revenue made in a particular month and the bubble color shows … Continue reading →

Posted in Charts, Excel Tricks | Tagged , | 7 Comments

Interactive English League Bumps Chart

Posted on August 17, 2008 by XLCubedBlog

This bumps chart shows you the English Premier League 2007 – 2008. It allows you to highlight and compare two teams by clicking a team in in the table or a line in the bumps charts. Interactively highlighting a data … Continue reading →

Posted in Charts, Excel Tricks | Tagged , | 5 Comments

Hyperlink Legends to Highlight a Series

Posted on August 14, 2008 by XLCubedBlog

In a recent post Jon presented a way to dynamically hover over the chart legend to highlight a data series. Jon’s method is very smart, as it really shows the capabilities of the event rich Excel chart programing model.  The … Continue reading →

Posted in Charts, Excel Tricks | Tagged , | 2 Comments

Creating rounded corners in Excel Tables

Posted on June 14, 2008 by XLCubedBlog

Igor Asselbergs was contemplating the value of round corners in design. Is it eye-candy? Or does it add value to the user experience? He comes to the conclusion that rounded corners clearly make a difference.         “On … Continue reading →

Posted in Excel Tricks | Tagged | 12 Comments