Catherine France – XLCubed Blog ../../../ XLCubed Blog Thu, 16 Jun 2022 08:44:44 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Catherine France – XLCubed Blog ../../../ 32 32 Dashboard Titles ../../../2021/08/dashboard-titles/ ../../../2021/08/dashboard-titles/#respond Wed, 11 Aug 2021 08:33:00 +0000 https://blog.xlcubed.com/?p=6343 Interactive and responsive dashboard sheets have been a core feature of XLCubed for a number of years. Version 10.0.81 introduced dashboard titles (with additional improvements added in 10.0.98) as a further way to simplify the dashboarding process. Titles can be added to any existing dashboard item. They can contain a text label as well as […]

The post Dashboard Titles appeared first on XLCubed Blog.

]]> ../../../2021/08/dashboard-titles/feed/ 0 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 – 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 Custom Grid & Table Headers For Dynamic Sorting ../../../2020/02/custom-grid-table-headers-for-dynamic-sorting/ ../../../2020/02/custom-grid-table-headers-for-dynamic-sorting/#comments Thu, 13 Feb 2020 13:37:41 +0000 https://blog.xlcubed.com/?p=5850 Consider this simple grid. It shows a ranking of the top 10 products by Sales Amount. We are going to add our own headers to this grid allowing us to create our own column names as well as implement custom functionality for dynamic ranking. Creating Custom Headers First, we need to hide the grid’s current […]

The post Custom Grid & Table Headers For Dynamic Sorting appeared first on XLCubed Blog.

]]> ../../../2020/02/custom-grid-table-headers-for-dynamic-sorting/feed/ 1 Grid Favourites ../../../2020/01/grid-favourites/ ../../../2020/01/grid-favourites/#respond Fri, 17 Jan 2020 14:29:43 +0000 https://blog.xlcubed.com/?p=5497 Do you ever find yourself creating the same grid over and over again? Sometimes we want to add the same grid multiple times but with a few variations, or in different workbooks. This can be especially tiresome if the grid has complex member selections or if the underlying data model has a large number of […]

The post Grid Favourites appeared first on XLCubed Blog.

]]> ../../../2020/01/grid-favourites/feed/ 0 Warning: Excel Can Get Volatile (revised) ../../../2019/10/warning-excel-can-get-volatile-revised/ ../../../2019/10/warning-excel-can-get-volatile-revised/#respond Fri, 04 Oct 2019 12:01:15 +0000 https://blog.xlcubed.com/?p=5810 This is a revised version of this post: Warning: Excel can get Volatile Excel is a great tool for dashboard/report delivery and design (it’s why we created our addin in the first place!), but there is a hidden performance trap: Offset, Now, Today, Cell, Indirect, Info and Rand If you’ve ever used any of these […]

The post Warning: Excel Can Get Volatile (revised) appeared first on XLCubed Blog.

]]> ../../../2019/10/warning-excel-can-get-volatile-revised/feed/ 0 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