Excel charts – XLCubed Blog

How to gauge data through charts – Creating Gauge Charts

XLCubed — Thu, 28 Jul 2016 13:25:38 +0000

A common question that comes up in support for XL Cubed is how to add charts that look like a dial, or a gauge. Something like the below: These are actually very easy to make and publish to the web, plus they have the further bonus of adding something […]

The post How to gauge data through charts – Creating Gauge Charts appeared first on XLCubed Blog.

Heatmap Tables with Excel – Revisited

XLCubed — Mon, 11 Jul 2011 10:42:55 +0000

We’ve revisited one of our more popular guides Heatmap Tables with Excel as they can be a very effective way of presenting data on a dashboard, and have now updated it for Excel 2010… This Heatmap Table is designed to show you the revenues and the discounts of a company over the course of one year […]

The post Heatmap Tables with Excel – Revisited appeared first on XLCubed Blog.

Flexible time-series graphing from a slicer

XLCubed — Tue, 05 Jul 2011 09:03:16 +0000

We are often asked how to drive a chart from a slicer in XLCubed and how to plot days/months for a month or year. Base case this is fairly straightforward, you can set up a grid which is based on the previous ‘x’ months of a slicer selection for example. The difficulty can be where you want […]

The post Flexible time-series graphing from a slicer appeared first on XLCubed Blog.

Heatmap Tables with Excel

XLCubed — Sun, 24 Aug 2008 03:41:42 +0000

The following article shows how to create Heatmaps in Excel 2003, for Excel 2007 & 2010 please see the updated article “Heatmap Tables with Excel – Revisited” 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 post Heatmap Tables with Excel appeared first on XLCubed Blog.

Hyperlink Legends to Highlight a Series

XLCubed — Thu, 14 Aug 2008 01:47:03 +0000

So I picked up Jon’s idea and tried to combine it with ParamLink. In The Missing Link I introduced the (free) ParamLink Add-In. It implements a new hyperlink formula ParamLink(). When the hyperlink is followed the formula can set cell values or define names. To highlight a data series you have to click on the […]

The post Hyperlink Legends to Highlight a Series appeared first on XLCubed Blog.

Small charts are beautiful

XLCubed — Thu, 08 May 2008 07:00:21 +0000

Well, since you are reading this, I’ll assume that you took the red pill, so let’s keep moving and find out how deep the rabbit hole goes. We saw that people usually design charts larger than they need to be. Why? Is it because we can’t fit the data into a smaller space? No, it […]

The post Small charts are beautiful appeared first on XLCubed Blog.