In-Cell Charts – XLCubed Blog

Excel heat maps made easy!

XLCubed — Wed, 22 Oct 2014 13:54:14 +0000

With the recent release of version 8 we’re going to blog about a number of the new features, starting with how to create a heat map in Excel. Here’s a fairly large table showing sales for thirty six products across twenty six US states: There’s a lot of data here but it’s not giving […]

The post Excel heat maps made easy! appeared first on XLCubed Blog.

Some Excel BI myths debunked #2: Inflexible Charting

XLCubed — Tue, 13 Aug 2013 10:48:29 +0000

#2: Inflexible Charting Continuing our discussion of common criticisms of Excel focused BI, let’s take a look at charting. “Excel charts are static, inflexible and you need to start from scratch if you want to change them.“ The flipside is that everyone knows how to use them, and in reality many charts in business reporting […]

The post Some Excel BI myths debunked #2: Inflexible Charting appeared first on XLCubed Blog.

Bandlines in XLCubed

XLCubed — Fri, 25 Jan 2013 09:47:43 +0000

In early January this year Stephen Few introduced the concept of Bandlines. He identified a useful extension to Sparklines, making use of shaded or coloured horizontal bands to provide more information on the context of the trend line itself. See Stephen’s article on Bandlines and the thinking behind them for a detail description. The Sparklines are ideal for […]

The post Bandlines in XLCubed appeared first on XLCubed Blog.

Something on the Horizon

XLCubed — Mon, 01 Aug 2011 10:14:13 +0000

We had an interesting scenario while helping a customer extend an existing Excel dashboard. We had recently performed some work to solve some performance and design issues they had with their existing Analysis Services cubes. They now had more of their underlying data available and the ability to query longer periods without the performance hit (a year’s worth […]

The post Something on the Horizon appeared first on XLCubed Blog.

Data Visualization – a real world example

XLCubed — Tue, 02 Mar 2010 06:57:47 +0000

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 most important point is that you have to define your audience. We receive many questions […]

The post Data Visualization – a real world example appeared first on XLCubed Blog.