Graphical tables – XLCubed Blog ../../../ XLCubed Blog Thu, 10 Jan 2019 09:16:35 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Graphical tables – XLCubed Blog ../../../ 32 32 Heatmap Tables with Excel – Revisited ../../../2011/07/heatmap-tables-with-excel-revisited/ ../../../2011/07/heatmap-tables-with-excel-revisited/#comments Mon, 11 Jul 2011 10:42:55 +0000 http://blog.xlcubed.com/?p=2622 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.

]]> ../../../2011/07/heatmap-tables-with-excel-revisited/feed/ 13 In-Cell Variance Charts ../../../2008/07/in-cell-variance-charts/ ../../../2008/07/in-cell-variance-charts/#comments Thu, 24 Jul 2008 01:38:53 +0000 http://blog.xlcubed.com/?p=312 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 even 10 lines requires row by row number comparison, and is not something which can […]

The post In-Cell Variance Charts appeared first on XLCubed Blog.

]]> ../../../2008/07/in-cell-variance-charts/feed/ 3 Graphical Tables – An Alternative to Treemaps ../../../2008/06/graphical-tables-an-alternative-to-treemaps/ ../../../2008/06/graphical-tables-an-alternative-to-treemaps/#comments Wed, 11 Jun 2008 03:25:26 +0000 http://blog.xlcubed.com/?p=111 Sean blogged the other day about using a treemap to visualize the drivers of the Australian Inflation. He got inspired to create a treemap by an NYT article that used an interactive version of the following treemap: This chart looks nice on the first view. It makes nice use of muted colors, the shapes look […]

The post Graphical Tables – An Alternative to Treemaps appeared first on XLCubed Blog.

]]> ../../../2008/06/graphical-tables-an-alternative-to-treemaps/feed/ 3