Variable width column charts and histograms Thumb

Variable width column charts and histograms in Excel

In Excel, the standard column chart will display all columns with the same width at regular intervals.  However, in some circumstances, it would be better for the width of each column to be different.  For example, where each column represents different ranges of data.  This same principle of column width also applies to histograms. Excel Read More

Change image based on cell value Thumb

3 ways to change an image based on a cell value

From stock parts to holiday villas, from employees to logos, there are many reasons you may want to automatically change an image based on a cell value.  In this post, we’ll explore 3 different methods to achieve this task: Named range + INDEX/MATCH + linked picture Chart fill + #N/A VBA User-Defined Function Each solution Read More

Custom Map Charts Thumb

Creating custom Map Charts using shapes and VBA

Whenever I see promotional images for expensive BI Dashboard software, they always show the same thing – a map with countries or regions highlighted in different colors.  It sends the subtle message that maps are the pinnacle of Business Intelligence (whether they are or not is a different matter altogether).  Until Excel 2016, these Map Read More