Category Archives: Charts

Data Visualization – a real world example

Posted on March 2, 2010 by XLCubedBlog

In the following example we work through a real world example of a data visualization. We’ve chosen an example that involves Operations data – this is fairly non-domain specific so hopefully it can demonstrate some important points. The first, and … Continue reading →

Posted in Analytics, BI, Case Studies, Charts, Dashboard, Reporting, Sparklines, Visualization | 3 Comments

Chart Tamer Beta Released

Posted on February 10, 2009 by XLCubedBlog

Update 5/2/2009: Chart Tamer is released. You can download the final version here. We released today a beta version of our latest BonaVista product Chart Tamer. We released Chart Tamer as a private beta to a group of Excel Experts: … Continue reading →

Posted in Charts | Tagged , , | 21 Comments

(de)Faults in Excel Charting

Posted on September 27, 2008 by XLCubedBlog

I recently spoke at SQLBitsIII, and an aspect which went down well was a simple overview on how to make the most important aspect of a graph, namely the underlying data, the prime focus and clear and easy to read. … Continue reading →

Posted in Charts, Visualization | 2 Comments

Household Income Distribution 1967 – 2005 As Small Multiples Chart

Posted on September 23, 2008 by XLCubedBlog

In my last post I tied to fix an overloaded line chart Jorge presented in a recent post about loss aversion: Jorge asked "does it make any sense to add those nine series to a single chart?“ My attempt to … Continue reading →

Posted in Charts | Tagged | 10 Comments

Using Color to Group and Label in Charts

Posted on September 17, 2008 by XLCubedBlog

Jorge wrote in a recent post about loss aversion, the fact that “people strongly prefer avoiding losses than acquiring gains”. Loss aversion [...]: Translated to chart-making, it means that there is a “tendency to avoid losing data at any cost”. … Continue reading →

Posted in Charts | Tagged , | 20 Comments

Fit a Micro Chart to Cell

Posted on September 7, 2008 by XLCubedBlog

Ever wondered how to get a Micro Bar Chart or a bullet graph that automatically changes the width when you change the cell width? The key to fitting a MicroChart into a cell is the CELL() function. The CELL function … Continue reading →

Posted in Charts, Sparklines | Tagged | 2 Comments

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

In-Cell Variance Charts

Posted on July 24, 2008 by XLCubedBlog

In financial report we are constantly comparing the actual numbers with our projections using variances. A quick reminder Absolute variance = Actual – Budget Relative variance in % = (Actual – Budget) / Budget Doing this over a report of … Continue reading →

Posted in Charts | Tagged | 2 Comments