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

Spreadsheet-Day-17-October-Thumb

Spreadsheet Day 2017

Happy Spreadsheet Day! What are your feelings about allocating days to celebration or awareness of certain things?  Like International Talk Like a Pirate Day (19th September), Oatmeal Nut Waffles Day (11th March) or Bathtub Day (7th October)?  Well, the 17 October is International Spreadsheet day.  Normally, I would think these days are pointless, but I 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

Reverse engineering a standard Excel Ribbon Thumb

Reverse engineering a standard Excel Ribbon

In July 2017, I released the Calc Buddy Add-in.  It’s a tool which monitors Excel’s calculation mode and shows a warning whenever it is different to the user’s preferred setting.  As I was getting the Add-in ready for release, I decided I wanted the button to be within the Calculation section of the Formula Ribbon.  Read More

Build your own Excel Add-in thumb

Build your own Add-in: Calculation Timer

In this post, I will show you, step-by-step, how to create an Add-in with its own custom Ribbon.  Rather than just creating an example Add-in which says, “Hello World!”, we will build something useful – a calculation timer.  The process of creating any Add-in will be similar, so you can apply these principles to your Read More