Excel Tricks – XLCubed Blog ../../../ XLCubed Blog Thu, 16 Jun 2022 08:44:44 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Excel Tricks – XLCubed Blog ../../../ 32 32 Warning: Excel Can Get Volatile (revised) ../../../2019/10/warning-excel-can-get-volatile-revised/ ../../../2019/10/warning-excel-can-get-volatile-revised/#respond Fri, 04 Oct 2019 12:01:15 +0000 https://blog.xlcubed.com/?p=5810 This is a revised version of this post: Warning: Excel can get Volatile Excel is a great tool for dashboard/report delivery and design (it’s why we created our addin in the first place!), but there is a hidden performance trap: Offset, Now, Today, Cell, Indirect, Info and Rand If you’ve ever used any of these […]

The post Warning: Excel Can Get Volatile (revised) appeared first on XLCubed Blog.

]]> ../../../2019/10/warning-excel-can-get-volatile-revised/feed/ 0 Linking it all together ../../../2019/04/linking-it-all-together/ ../../../2019/04/linking-it-all-together/#respond Thu, 04 Apr 2019 12:26:33 +0000 https://blog.xlcubed.com/?p=4739 As we’ve seen in the past, XL3Link is a flexible formula that is really worth knowing about to help easily build interlinked reports. To some extent it’s like a Swiss army knife – multi-purpose!  From highlighting a series on a chart to hosting a tooltip,  XL3Link is a flexible formula that can help make your reporting more interactive at multiple levels. […]

The post Linking it all together appeared first on XLCubed Blog.

]]> ../../../2019/04/linking-it-all-together/feed/ 0 A snappy fix for layout problems in Excel ../../../2012/07/a-snappy-fix-for-layout-problems-in-excel/ ../../../2012/07/a-snappy-fix-for-layout-problems-in-excel/#comments Mon, 02 Jul 2012 14:53:35 +0000 http://blog.xlcubed.com/?p=3430 Have you ever tried copying parts of one workbook to another and been restricted by column widths?  Or maybe you’re almost done with a report layout only to find that the last table you need to add has 4 columns, where there is only room for 3?  Today we’re going to show you how to […]

The post A snappy fix for layout problems in Excel appeared first on XLCubed Blog.

]]> ../../../2012/07/a-snappy-fix-for-layout-problems-in-excel/feed/ 2 Drive Excel Chart Min/Max from Range ../../../2011/10/drive-excel-chart-minmax-from-range/ ../../../2011/10/drive-excel-chart-minmax-from-range/#respond Tue, 18 Oct 2011 09:39:10 +0000 http://blog.xlcubed.com/?p=3132 How do I drive the min and max values of an axis from an Excel Range? This is one of the most commonly asked questions about Excel and with each new release it always amazes me that this feature hasn’t been added to the base product. It’s a very common scenario to come across, you are building […]

The post Drive Excel Chart Min/Max from Range appeared first on XLCubed Blog.

]]> ../../../2011/10/drive-excel-chart-minmax-from-range/feed/ 0 Warning: Excel can get Volatile ../../../2011/08/warning-excel-can-get-volatile/ ../../../2011/08/warning-excel-can-get-volatile/#respond Mon, 29 Aug 2011 09:00:16 +0000 http://blog.xlcubed.com/?p=3022 There is a revised version of this post here. Excel is a great tool for dashboard/report delivery and design (it’s why we created our addin in the first place), but there is a hidden performance trap: Offset, Now, Today, Cell, Indirect, Info and Rand If you’ve ever used any of these formulae, you may have […]

The post Warning: Excel can get Volatile appeared first on XLCubed Blog.

]]> ../../../2011/08/warning-excel-can-get-volatile/feed/ 0 Heatmap Tables with Excel ../../../2008/08/heatmap-tables-with-excel/ ../../../2008/08/heatmap-tables-with-excel/#comments Sun, 24 Aug 2008 03:41:42 +0000 http://blog.xlcubed.com/?p=460 The following article shows how to create Heatmaps in Excel 2003, for Excel 2007 & 2010 please see the updated article “Heatmap Tables with Excel – Revisited” This Heatmap Table shows you the revenues and the discounts of a company over the course of one year per product group. The size of a bubble shows […]

The post Heatmap Tables with Excel appeared first on XLCubed Blog.

]]> ../../../2008/08/heatmap-tables-with-excel/feed/ 8 Interactive English League Bumps Chart ../../../2008/08/interactive-english-league-bumps-chart/ ../../../2008/08/interactive-english-league-bumps-chart/#comments Sat, 16 Aug 2008 23:25:59 +0000 http://blog.xlcubed.com/?p=426 This bumps chart shows you the English Premier League 2007 – 2008. It allows you to highlight and compare two teams by clicking a team in in the table or a line in the bumps charts.   Interactively highlighting a data series in a large data set is very powerful. All lines in the data […]

The post Interactive English League Bumps Chart appeared first on XLCubed Blog.

]]> ../../../2008/08/interactive-english-league-bumps-chart/feed/ 5 Hyperlink Legends to Highlight a Series ../../../2008/08/hyperlink-legends-to-highlight-a-series/ ../../../2008/08/hyperlink-legends-to-highlight-a-series/#comments Thu, 14 Aug 2008 01:47:03 +0000 http://blog.xlcubed.com/?p=423 So I picked up Jon’s idea and tried to combine it with ParamLink. In  The Missing Link I introduced the (free) ParamLink Add-In. It implements a new hyperlink formula ParamLink(). When the hyperlink is followed the formula can set cell values or define names. To highlight a data series you have to click on the […]

The post Hyperlink Legends to Highlight a Series appeared first on XLCubed Blog.

]]> ../../../2008/08/hyperlink-legends-to-highlight-a-series/feed/ 2 Creating rounded corners in Excel Tables ../../../2008/06/creating-rounded-corners-in-excel-tables/ ../../../2008/06/creating-rounded-corners-in-excel-tables/#comments Sat, 14 Jun 2008 03:44:19 +0000 http://blog.xlcubed.com/?p=138 ** Please see also the updated article, for XLCubed v7.1 and above: http://blog.xlcubed.com/2012/09/creating-rounded-corners-in-excel-revisited/ **   Igor Asselbergs was contemplating the value of round corners in design. Is it eye-candy? Or does it add value to the user experience? He comes to the conclusion that rounded corners clearly make a difference.         “On the left […]

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

]]> ../../../2008/06/creating-rounded-corners-in-excel-tables/feed/ 15