Dashboard – 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 Dashboard – XLCubed Blog ../../../ 32 32 XLCubed: A Beginner’s Advice ../../../2019/05/xlcubed-a-beginners-advice/ ../../../2019/05/xlcubed-a-beginners-advice/#respond Thu, 02 May 2019 09:20:24 +0000 https://blog.xlcubed.com/?p=5328 I have been working with XLCubed for approximately two weeks now and when I first started, I wasn’t sure what to expect. I had come from a Mathematics background and so had no in-depth technical IT background. Over the last two weeks, my main priority has been to get to know XLCubed like the back […]

The post XLCubed: A Beginner’s Advice appeared first on XLCubed Blog.

]]> ../../../2019/05/xlcubed-a-beginners-advice/feed/ 0 Dashboard Designs: Dynamic Cards ../../../2019/01/dashboard-designs-dynamic-cards/ ../../../2019/01/dashboard-designs-dynamic-cards/#respond Thu, 31 Jan 2019 13:27:10 +0000 https://blog.xlcubed.com/?p=4969 Dashboard cards are a great way to group related data and make key information more accessible. The flexibility of Excel and XLCubed means there are a number of ways you might choose the incorporate a card-based design into your dashboards. In this blog we will consider one way to do this using XLCubed dashboard sheets […]

The post Dashboard Designs: Dynamic Cards appeared first on XLCubed Blog.

]]> ../../../2019/01/dashboard-designs-dynamic-cards/feed/ 0 Dashboard Designs: Responsive Navigation Bars ../../../2018/12/dashboard-designs-responsive-navigation-bars/ ../../../2018/12/dashboard-designs-responsive-navigation-bars/#comments Thu, 06 Dec 2018 08:56:10 +0000 https://blog.xlcubed.com/?p=4646 Many would believe that Excel is a static environment and not suited for making responsive mobile reports. XLCubed users know better. With XLCubed’s Dashboard Designer, it is possible to create dashboards that are not only interactive and data-connected, but also responsive to fit any device. If you are new to XLCubed Dashboards, read this article […]

The post Dashboard Designs: Responsive Navigation Bars appeared first on XLCubed Blog.

]]> ../../../2018/12/dashboard-designs-responsive-navigation-bars/feed/ 2 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 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 Workbook slicers – all for one and one for all! ../../../2014/10/workbook-slicers-all-for-one-and-one-for-all/ ../../../2014/10/workbook-slicers-all-for-one-and-one-for-all/#comments Tue, 28 Oct 2014 16:47:48 +0000 http://blog.xlcubed.com/?p=4144 So this is our second blog on the new features of XLCubed v8 – today we’re going to run through workbook slicers. Workbook slicers allow the user to create the slicers at the workbook level so that they can be displayed for any/all sheets. There’s a slicer pane which can be arranged horizontally or vertically […]

The post Workbook slicers – all for one and one for all! appeared first on XLCubed Blog.

]]> ../../../2014/10/workbook-slicers-all-for-one-and-one-for-all/feed/ 4 Some Excel BI myths debunked: #3 – limited dashboards ../../../2013/08/some-excel-bi-myths-debunked-3-limited-dashboards/ ../../../2013/08/some-excel-bi-myths-debunked-3-limited-dashboards/#comments Wed, 21 Aug 2013 08:41:33 +0000 http://blog.xlcubed.com/?p=3946 #3: Limited and difficult to Maintain Dashboards Third on our list of common criticisms of Excel focused BI, is the limitations of Excel Dashboards. “Excel dashboards are ugly, limited, and inflexible…” It’s possible to build a truly awful dashboard in pretty much any dashboard tool. No tool is magic, ignoring the Doctor’s Sonic Screwdriver of […]

The post Some Excel BI myths debunked: #3 – limited dashboards appeared first on XLCubed Blog.

]]> ../../../2013/08/some-excel-bi-myths-debunked-3-limited-dashboards/feed/ 1 Current and Previous month reporting made easy ../../../2013/07/current-and-previous-month-reporting-made-easy/ ../../../2013/07/current-and-previous-month-reporting-made-easy/#respond Thu, 18 Jul 2013 12:07:13 +0000 http://blog.xlcubed.com/?p=3896 We’ve all been there. Our shiny new dashboard or report pack is finished and ready to go meet its users.  We’ve presented the key information clearly, we’ve followed all the data vis guidelines on effective charting and use of colour. We like it a lot, and we’ve thought ahead and built in lots of flexibility […]

The post Current and Previous month reporting made easy appeared first on XLCubed Blog.

]]> ../../../2013/07/current-and-previous-month-reporting-made-easy/feed/ 0 Bandlines in XLCubed ../../../2013/01/bandlines-in-xlcubed/ ../../../2013/01/bandlines-in-xlcubed/#comments Fri, 25 Jan 2013 09:47:43 +0000 http://blog.xlcubed.com/?p=3797 In early January this year Stephen Few introduced the concept of Bandlines. He identified a useful extension to Sparklines, making use of shaded or coloured horizontal bands to provide more information on the context of the trend line itself. See Stephen’s article on Bandlines and the thinking behind them for a detail description. The Sparklines are ideal for […]

The post Bandlines in XLCubed appeared first on XLCubed Blog.

]]> ../../../2013/01/bandlines-in-xlcubed/feed/ 9 XLCubed as an alternative to ProClarity ../../../2012/11/xlcubed-as-an-alternative-to-proclarity/ ../../../2012/11/xlcubed-as-an-alternative-to-proclarity/#respond Mon, 12 Nov 2012 11:18:08 +0000 http://blog.xlcubed.com/?p=3716 With the launch of 7.1 of XLCubed Excel Edition we introduced the ability to import ProClarity Briefing Books – with support for ProClarity ending this year and many customers looking for a replacement, now is a great time for us to show you how the import works to help move users from ProClarity to an alternate solution. Importing […]

The post XLCubed as an alternative to ProClarity appeared first on XLCubed Blog.

]]> ../../../2012/11/xlcubed-as-an-alternative-to-proclarity/feed/ 0