Small Multiples – XLCubed Blog ../../../ XLCubed Blog Tue, 05 Nov 2019 14:52:10 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Small Multiples – XLCubed Blog ../../../ 32 32 Interactive Charting In Excel and Web ../../../2019/07/interactive-charting-in-excel-and-web/ ../../../2019/07/interactive-charting-in-excel-and-web/#respond Fri, 05 Jul 2019 09:11:21 +0000 https://blog.xlcubed.com/?p=5583 Proper data visualisation is essential for digestible reports and dashboards. Business charting needs to not only portray a true representation of the data, but must also be intuitive and dynamic in its use. Any user should be able to click around or drill into the chart/report to find the view that they need. XLCubed v9.2 […]

The post Interactive Charting In Excel and Web appeared first on XLCubed Blog.

]]> ../../../2019/07/interactive-charting-in-excel-and-web/feed/ 0 Dynamic Dashboards In Excel – Tutorial ../../../2019/06/dynamic-dashboards-in-excel-tutorial/ ../../../2019/06/dynamic-dashboards-in-excel-tutorial/#respond Thu, 06 Jun 2019 07:57:50 +0000 https://blog.xlcubed.com/?p=5204 In this post we will walk through how to use XLCubed’s dashboard sheets to create a responsive dashboard within Excel, that will work on any device! You can access the report here: Live web version Excel file (no data connection needed, but you will need XLCubed v9.2 installed) Create a dashboard sheet Add a dashboard sheet […]

The post Dynamic Dashboards In Excel – Tutorial appeared first on XLCubed Blog.

]]> ../../../2019/06/dynamic-dashboards-in-excel-tutorial/feed/ 0 Visual Analytics for Excel ../../../2018/11/visual-analytics-for-excel/ ../../../2018/11/visual-analytics-for-excel/#respond Wed, 28 Nov 2018 09:36:58 +0000 https://blog.xlcubed.com/?p=4619 One of the biggest improvements in 9.2 is undoubtedly in the area of interactive charting. We’ve hugely extended the capabilities of Small Multiples through a new charting engine which brings rich interactive Visual Analytics to Excel (and web, and mobile…). The ‘Small Multiple’ concept of many charts with a shared axis is very powerful, but […]

The post Visual Analytics for Excel appeared first on XLCubed Blog.

]]> ../../../2018/11/visual-analytics-for-excel/feed/ 0 Bump Charts in XLCubed ../../../2014/12/bump-charts-in-xlcubed/ ../../../2014/12/bump-charts-in-xlcubed/#respond Tue, 09 Dec 2014 16:24:47 +0000 http://blog.xlcubed.com/?p=4169 So today’s blog is about adding Bump Charts in Excel using v8 XLCubed. Initially a Bump Chart looks the same as a line chart – the difference is they plot the rank position rather than the actual value. Let’s imagine that I sell a product in a marketplace with 10 other competitors. I may like […]

The post Bump Charts in XLCubed appeared first on XLCubed Blog.

]]> ../../../2014/12/bump-charts-in-xlcubed/feed/ 0 Some Excel BI myths debunked #2: Inflexible Charting ../../../2013/08/some-excel-bi-myths-debunked-2-inflexible-charting/ ../../../2013/08/some-excel-bi-myths-debunked-2-inflexible-charting/#respond Tue, 13 Aug 2013 10:48:29 +0000 http://blog.xlcubed.com/?p=3922 #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.

]]> ../../../2013/08/some-excel-bi-myths-debunked-2-inflexible-charting/feed/ 0 Small Multiples on River Quality ../../../2011/08/small-multiples-on-river-quality/ ../../../2011/08/small-multiples-on-river-quality/#respond Mon, 15 Aug 2011 10:58:01 +0000 http://blog.xlcubed.com/?p=2922 The phrase small multiple was popularised by Edward Tufte, and has become a generic term for a visual display using the same chart or graphic to display different slices of a data set. Their close positioning and shared scale make comparisons very easy and shared trends or outliers can be quickly spotted. Various other terms are […]

The post Small Multiples on River Quality appeared first on XLCubed Blog.

]]> ../../../2011/08/small-multiples-on-river-quality/feed/ 0