XLCubed – XLCubed Blog ../../../ XLCubed Blog Tue, 07 Jun 2022 12:36:09 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png XLCubed – XLCubed Blog ../../../ 32 32 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 How’d you like that….displayed! ../../../2018/10/howd-you-like-that-displayed/ ../../../2018/10/howd-you-like-that-displayed/#comments Wed, 17 Oct 2018 14:50:59 +0000 https://blog.xlcubed.com/?p=4506 Today’s blog will show you a really quick and easy way to format your grid to show different display units. This approach is ideal for dynamic Grids where the size of the values can vary considerably based on the selected filters, or where the user has drilled down to lower levels in the data. For […]

The post How’d you like that….displayed! appeared first on XLCubed Blog.

]]> ../../../2018/10/howd-you-like-that-displayed/feed/ 2 No comment? We’ve got plenty to say! ../../../2018/09/no-comment-weve-got-plenty-to-say/ ../../../2018/09/no-comment-weve-got-plenty-to-say/#respond Thu, 13 Sep 2018 15:00:53 +0000 https://blog.xlcubed.com/?p=4483 Today’s blog will run through XLCubed’s commentary functionality. At XLCubed we have seen a lot of customer interest in commentary and collaboration in the last couple of years. We’re all familiar with the standard comments functionality in Excel where you add a comment to an Excel cell. However, in a dynamic BI environment it can […]

The post No comment? We’ve got plenty to say! appeared first on XLCubed Blog.

]]> ../../../2018/09/no-comment-weve-got-plenty-to-say/feed/ 0 Using Slicers for Sheet Navigation ../../../2018/07/using-slicers-for-sheet-navigation/ ../../../2018/07/using-slicers-for-sheet-navigation/#respond Mon, 02 Jul 2018 14:03:03 +0000 https://blog.xlcubed.com/?p=4474 Slicers are normally used to change filter selections in a report, but a less well-known use is for report navigation, to allow users to jump to another location in the workbook. Here I have a report with several sheets. I would like to hide all the tabs at the bottom upon publishing and just have […]

The post Using Slicers for Sheet Navigation appeared first on XLCubed Blog.

]]> ../../../2018/07/using-slicers-for-sheet-navigation/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 Making your (Power)Point ../../../2018/03/making-your-powerpoint/ ../../../2018/03/making-your-powerpoint/#comments Tue, 27 Mar 2018 13:38:55 +0000 https://blog.xlcubed.com/?p=4448 Over the last year or so several customers have asked about the ability to export XLCubed reports directly into PowerPoint.  They were doing this manually as part of regular monthly reporting cycles, and wanted to automate what was a fairly tedious process, and to save time. We took these requests on board and are pleased […]

The post Making your (Power)Point appeared first on XLCubed Blog.

]]> ../../../2018/03/making-your-powerpoint/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 User control of dashboard layouts ../../../2017/08/user-control-of-dashboard-layouts/ ../../../2017/08/user-control-of-dashboard-layouts/#respond Fri, 18 Aug 2017 13:00:43 +0000 https://blog.xlcubed.com/?p=4393 Dashboard sheets were introduced with V9, primarily as a way to deliver mobile-friendly reporting with a responsive UI to auto-fit any screen size. Specific Targets which define the layout can be defined to optimise the layout for different devices and are automatically applied depending on the device type. Another use-case which is less obvious but […]

The post User control of dashboard layouts appeared first on XLCubed Blog.

]]> ../../../2017/08/user-control-of-dashboard-layouts/feed/ 0 Icon-based Navigation and Filtering in XLCubed ../../../2017/08/icon-based-navigation-and-filtering-in-xlcubed/ ../../../2017/08/icon-based-navigation-and-filtering-in-xlcubed/#respond Tue, 01 Aug 2017 12:01:38 +0000 https://blog.xlcubed.com/?p=4365 Version 9 introduced an embedded icon library and XL3PictureLink, which together make the creation of icon-led navigation and filtering simple. XL3PictureLink provides the same parameterised navigation capabilities which the XL3Link() formula has done for years, but with an added visual aspect. Users can choose from one of the thousands of icons provided, in any colour, […]

The post Icon-based Navigation and Filtering in XLCubed appeared first on XLCubed Blog.

]]> ../../../2017/08/icon-based-navigation-and-filtering-in-xlcubed/feed/ 0 The Missing Link in Excel BI ../../../2017/03/the-missing-link-in-excel-bi/ ../../../2017/03/the-missing-link-in-excel-bi/#comments Fri, 03 Mar 2017 11:01:33 +0000 https://blog.xlcubed.com/?p=4344 When viewing a high level summary report or dashboard, users often want to delve into more detail on a specific area. In some cases that may be a drill down, in many others it may be to a different view of the data or to an entirely different report. In the XLCubed example below, users […]

The post The Missing Link in Excel BI appeared first on XLCubed Blog.

]]> ../../../2017/03/the-missing-link-in-excel-bi/feed/ 2