Dashboard Design – 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 Design – 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 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 Optimizing Excel Reports on Mobile Devices ../../../2019/05/optimizing-excel-reports-on-mobile-devices/ ../../../2019/05/optimizing-excel-reports-on-mobile-devices/#respond Wed, 15 May 2019 09:38:07 +0000 https://blog.xlcubed.com/?p=5435 Want to view your Excel report on a mobile device? Tired of having to zoom in on your data? Well then look no further, XLCubed has you covered! With the XLCubed Mobile App, you can take your Excel reports with you. Workbooks published to XLCubed Web can be accessed by other users on any mobile […]

The post Optimizing Excel Reports on Mobile Devices appeared first on XLCubed Blog.

]]> ../../../2019/05/optimizing-excel-reports-on-mobile-devices/feed/ 0 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 Member Searching To Create A Product Details Page ../../../2019/03/member-searching-to-create-a-product-details-page/ ../../../2019/03/member-searching-to-create-a-product-details-page/#respond Wed, 27 Mar 2019 10:13:03 +0000 https://blog.xlcubed.com/?p=5080 XLCubed is a great tool when it comes to member searching: it allows you to quickly and easily find members as well as dynamically update a report based on search parameters. Take a read of our last post to get started with this functionality. The example in this post uses these searching methods to create […]

The post Member Searching To Create A Product Details Page appeared first on XLCubed Blog.

]]> ../../../2019/03/member-searching-to-create-a-product-details-page/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 Christmas Dashboard ../../../2018/12/christmas-dashboard/ ../../../2018/12/christmas-dashboard/#respond Tue, 18 Dec 2018 10:49:32 +0000 https://blog.xlcubed.com/?p=4667 Ever wondered how Santa Claus keeps track of the North Pole’s toy production all year round? He uses XLCubed of course! Take a look at the dashboard below…. There are a few key features of this dashboard: Charts and Viewports The areas displaying charts and the grid are brought onto the dashboard using paged viewports. This […]

The post Christmas Dashboard appeared first on XLCubed Blog.

]]> ../../../2018/12/christmas-dashboard/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