Grid & Report Formatting – XLCubed Blog ../../../ XLCubed Blog Thu, 21 Oct 2021 09:19:40 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Grid & Report Formatting – XLCubed Blog ../../../ 32 32 Chart-driven Table Highlighting ../../../2021/10/chart-driven-table-highlighting/ ../../../2021/10/chart-driven-table-highlighting/#respond Thu, 21 Oct 2021 09:19:37 +0000 https://blog.xlcubed.com/?p=6376 Recently a customer raised a support issue asking if it was possible to highlight a row within a table based on a selection made in a chart. Interactive charting being a core XLCubed feature, of course it is! Here we can click on a country to highlight the relevant rows or we can go one […]

The post Chart-driven Table Highlighting appeared first on XLCubed Blog.

]]> ../../../2021/10/chart-driven-table-highlighting/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 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 Using Grid Styles in XLCubed ../../../2019/08/using-grid-styles-in-xlcubed/ ../../../2019/08/using-grid-styles-in-xlcubed/#comments Wed, 14 Aug 2019 12:30:15 +0000 https://blog.xlcubed.com/?p=4986 This week’s blog is a quick tip on Grid formatting options. Did you know that XLCubed comes with ten pre-formatted grid styles which you can easily switch between? These are available from the Workbook Format button on the XLCubed ribbon (the option remains greyed out until an XLCubed grid is added). Grid styles allow for […]

The post Using Grid Styles in XLCubed appeared first on XLCubed Blog.

]]> ../../../2019/08/using-grid-styles-in-xlcubed/feed/ 4 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 Common Row Highlighting ../../../2019/02/common-row-highlighting/ ../../../2019/02/common-row-highlighting/#comments Wed, 20 Feb 2019 10:01:22 +0000 https://blog.xlcubed.com/?p=5027 Last week’s post looked at the fundamentals of formatting XLCubed grids. A lot can be done with these techniques but sometimes more interactive formatting is desired. Within an XLCubed grid you can set Interaction Options to track which cell has been selected and output the selection and/or format it. In this post, we will look at […]

The post Common Row Highlighting appeared first on XLCubed Blog.

]]> ../../../2019/02/common-row-highlighting/feed/ 1 Grid Formatting 101 ../../../2019/02/grid-formatting-101/ ../../../2019/02/grid-formatting-101/#respond Wed, 13 Feb 2019 11:04:18 +0000 https://blog.xlcubed.com/?p=5001 Most formatting in XLCubed can be handled though the formatting options available on the right-click menu, and today’s blog will cover some of the common use cases. You will be presented with different options depending on whether you click a member on columns or rows: or a cell within the grid: Selecting any of these […]

The post Grid Formatting 101 appeared first on XLCubed Blog.

]]> ../../../2019/02/grid-formatting-101/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 Creating rounded corners in Excel – revisited ../../../2012/09/creating-rounded-corners-in-excel-revisited/ ../../../2012/09/creating-rounded-corners-in-excel-revisited/#respond Mon, 24 Sep 2012 09:01:15 +0000 http://blog.xlcubed.com/?p=3674 Today we’re revisiting one of our more popular guides, Creating rounded corners in Excel Tables, and have updated it for v7.1. When Igor Asselbergs was contemplating the value of round corners in design, he came to the conclusion that in many cases they added real value to the user experience. The effect can be explained by the Gestalt Law of […]

The post Creating rounded corners in Excel – revisited appeared first on XLCubed Blog.

]]> ../../../2012/09/creating-rounded-corners-in-excel-revisited/feed/ 0 Mind the gap! ../../../2012/09/mind-the-gap/ ../../../2012/09/mind-the-gap/#comments Tue, 04 Sep 2012 16:12:33 +0000 http://blog.xlcubed.com/?p=3645 Today’s blog is going to show you how to use XLCubed’s custom calculation functionality to create column breaks in a grid.  Imagine that you have a report that shows you Reseller Sales across Product Model Categories over a 12-month time period.       There’s nothing wrong with this report but don’t you think it […]

The post Mind the gap! appeared first on XLCubed Blog.

]]> ../../../2012/09/mind-the-gap/feed/ 3