Grid 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 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 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 Formatting Tables in v7 ../../../2012/05/formatting-tables-in-v7/ ../../../2012/05/formatting-tables-in-v7/#respond Tue, 08 May 2012 14:43:26 +0000 http://blog.xlcubed.com/?p=3280 We’ve had some great feedback from our Newsletter announcing the release of v7.  A number of users have asked how we created the example in the Newsletter: So,  today we’re going to show you how to achieve some of the formatting that is now available when using SQL tables in v7. Let’s create a SQL […]

The post Formatting Tables in v7 appeared first on XLCubed Blog.

]]> ../../../2012/05/formatting-tables-in-v7/feed/ 0 Number Formats ../../../2011/08/number-formats/ ../../../2011/08/number-formats/#comments Mon, 08 Aug 2011 09:24:58 +0000 http://blog.xlcubed.com/?p=2907 One of the main reasons we use Excel is to analyse and display our data, for either our own consumption, or to show to others. In both cases, we want our data to be easily readable, and any important patterns to be immediately obvious. We use colours, borders and other formatting to highlight important characteristics of our data, and […]

The post Number Formats appeared first on XLCubed Blog.

]]> ../../../2011/08/number-formats/feed/ 5