Charts – XLCubed Blog ../../../ XLCubed Blog Mon, 05 Oct 2020 09:20:22 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Charts – XLCubed Blog ../../../ 32 32 Lessons from IBCS – Scenario Handling ../../../2020/10/lessons-from-ibcs-scenario-handling/ ../../../2020/10/lessons-from-ibcs-scenario-handling/#respond Mon, 05 Oct 2020 09:20:19 +0000 https://blog.xlcubed.com/?p=6218 In the previous blog, we looked at how consistency is important throughout a set of reports and dashboards. It helps users to understand the reports quickly and easily. Another important aspect to maintain is scenario handling; this forms the UNIFY part of IBCS’ SUCCESS formula. Scenarios are used to represent different types of business data […]

The post Lessons from IBCS – Scenario Handling appeared first on XLCubed Blog.

]]> ../../../2020/10/lessons-from-ibcs-scenario-handling/feed/ 0 Lessons from IBCS – Maintaining Visual Integrity ../../../2020/08/maintaining-visual-integrity/ ../../../2020/08/maintaining-visual-integrity/#respond Fri, 14 Aug 2020 07:46:24 +0000 https://blog.xlcubed.com/?p=6187 When reading reports and dashboards, we often find ourselves spending more time than we’d expect analysing the charts and tables tying to comprehend the data. In many cases that’s due to inconsistencies in the presentation, or poor design. Ideally a report should convey the message clearly and quickly. One of the underlying rules of IBCS […]

The post Lessons from IBCS – Maintaining Visual Integrity appeared first on XLCubed Blog.

]]> ../../../2020/08/maintaining-visual-integrity/feed/ 0 Lessons from IBCS – Eliminating Chart Clutter ../../../2020/08/eliminating-chart-clutter/ ../../../2020/08/eliminating-chart-clutter/#respond Thu, 06 Aug 2020 08:11:39 +0000 https://blog.xlcubed.com/?p=6133 The core job of a chart is to convey information to the viewer as clearly, concisely, and quickly as possible. One thing that can detract from this is chart clutter – distracting or unnecessary additional elements which can mask the overall message. “Simplicity is the ultimate sophistication” Leonardo da Vinci Edward Tufte coined the term […]

The post Lessons from IBCS – Eliminating Chart Clutter appeared first on XLCubed Blog.

]]> ../../../2020/08/eliminating-chart-clutter/feed/ 0 Lessons From IBCS – Choosing The Right Chart Type ../../../2020/07/choosing-the-right-chart-type/ ../../../2020/07/choosing-the-right-chart-type/#respond Thu, 16 Jul 2020 10:02:04 +0000 https://blog.xlcubed.com/?p=5972 Choosing the right chart type to display your data is key to communicating an understandable message to users. Bad or inconsistent use of chart types can lead to confusion and poor interpretations of the data. For a report to be effective, each visualisation must be carefully and deliberately chosen. In this post, we will outline […]

The post Lessons From IBCS – Choosing The Right Chart Type appeared first on XLCubed Blog.

]]> ../../../2020/07/choosing-the-right-chart-type/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 Eat, Sleep, Report, Repeat! ../../../2018/04/eat-sleep-report-repeat/ ../../../2018/04/eat-sleep-report-repeat/#comments Tue, 17 Apr 2018 09:51:21 +0000 https://blog.xlcubed.com/?p=4458 Repeaters are a visualisation feature introduced in v9.1.  They are effective when you want to repeat a formatted section of a report by one variable.  They can save so much time as you don’t have to go through the tedious, error-prone task of recreating the same section many times by copying and pasting manually.  Imagine […]

The post Eat, Sleep, Report, Repeat! appeared first on XLCubed Blog.

]]> ../../../2018/04/eat-sleep-report-repeat/feed/ 1 Charting the Premier League Transfer Window ../../../2017/09/charting-the-premier-league-transfer-window/ ../../../2017/09/charting-the-premier-league-transfer-window/#respond Thu, 14 Sep 2017 14:34:30 +0000 https://blog.xlcubed.com/?p=4417 This summer English Premier league clubs spent more than ever before on player transfers, a staggering £1.47bn in total. Some spent a lot more than others, and while PSG are making the Financial Fair Play headlines globally, the EPL clubs as a group spent more than any other league. There are lots of ways to […]

The post Charting the Premier League Transfer Window appeared first on XLCubed Blog.

]]> ../../../2017/09/charting-the-premier-league-transfer-window/feed/ 0 Rio Olympics – Medals Treemaps ../../../2016/08/rio-olympics-medals-treemaps/ ../../../2016/08/rio-olympics-medals-treemaps/#respond Mon, 22 Aug 2016 15:42:33 +0000 http://blog.xlcubed.com/?p=4301 Well, the Rio 2016 games have finished and we now all need to find something else to watch on TV. As always at the Olympics there was plenty to entertain and inspire. After the London games in 2012 we blogged showing the medal distribution using Treemaps. We’ve updated that for 2016 below with the corresponding 2012 […]

The post Rio Olympics – Medals Treemaps appeared first on XLCubed Blog.

]]> ../../../2016/08/rio-olympics-medals-treemaps/feed/ 0 How to gauge data through charts – Creating Gauge Charts ../../../2016/07/how-to-gauge-data-through-charts-creating-gauge-charts/ ../../../2016/07/how-to-gauge-data-through-charts-creating-gauge-charts/#comments Thu, 28 Jul 2016 13:25:38 +0000 http://blog.xlcubed.com/?p=4262 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.

]]> ../../../2016/07/how-to-gauge-data-through-charts-creating-gauge-charts/feed/ 2 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