IBCS – XLCubed Blog ../../../../ XLCubed Blog Mon, 01 Mar 2021 13:59:31 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png IBCS – XLCubed Blog ../../../../ 32 32 Scenario Comparisons With Variance Charts ../../../../2021/03/scenario-comparisons-with-variance-charts/ ../../../../2021/03/scenario-comparisons-with-variance-charts/#respond Mon, 01 Mar 2021 13:59:03 +0000 https://blog.xlcubed.com/?p=6323 Business data is often better understood when viewed in the context of another scenario. We need to know if we are doing better than this time last year, or how close we are to meeting our budget. Variance charts are effective at displaying these differences between actual and comparative values. They can show absolute or […]

The post Scenario Comparisons With Variance Charts appeared first on XLCubed Blog.

]]> ../../../../2021/03/scenario-comparisons-with-variance-charts/feed/ 0 Waterfall Charts for Profit and Loss Statements ../../../../2021/02/waterfall-charts-for-profit-and-loss-statements/ ../../../../2021/02/waterfall-charts-for-profit-and-loss-statements/#respond Tue, 02 Feb 2021 09:37:11 +0000 https://blog.xlcubed.com/?p=6263 Income statements, or Profit and Loss statements, are an essential part of any business. However, when displayed as a large table of numbers, it can be difficult to draw out the information needed to answer simple questions such as “how has my revenue changed compared to last year?” or “which region has the largest contribution […]

The post Waterfall Charts for Profit and Loss Statements appeared first on XLCubed Blog.

]]> ../../../../2021/02/waterfall-charts-for-profit-and-loss-statements/feed/ 0 Waterfall Charts in Excel – Time Analysis ../../../../2021/01/waterfall-charts-in-excel-time-analysis/ ../../../../2021/01/waterfall-charts-in-excel-time-analysis/#comments Fri, 08 Jan 2021 10:15:49 +0000 https://blog.xlcubed.com/?p=6246 Waterfall charts are a great way of visualising contributions to a total or a total variance. They allow you to analyse how a value is influenced by the cumulative effect of underlying positive or negative inputs. This can lead to quicker and more effective business insights. Waterfalls are available as a chart type with XLCubed, […]

The post Waterfall Charts in Excel – Time Analysis appeared first on XLCubed Blog.

]]> ../../../../2021/01/waterfall-charts-in-excel-time-analysis/feed/ 1 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 XLCubed and IBCS ../../../../2020/07/xlcubed-and-ibcs/ ../../../../2020/07/xlcubed-and-ibcs/#respond Tue, 07 Jul 2020 07:40:02 +0000 https://blog.xlcubed.com/?p=6034 In the last few months we have significantly extended the charting elements within XLCubed. We wanted to get the product formally certified by IBCS, and I’m delighted to say we achieved that in early June. We’ve been aware of IBCS for several years now through some of our customers and partners, but it was really […]

The post XLCubed and IBCS appeared first on XLCubed Blog.

]]> ../../../../2020/07/xlcubed-and-ibcs/feed/ 0