5 rules for a dashboard color palette

Dashboard color palette

In this post, I would like to consider the use of colors in a dashboard (or, for that matter any analysis tool which uses colors to highlight areas of interest).  Everybody believes they have good taste, even though everybody has different tastes.  When choosing colors for a dashboard the key consideration is not your taste … Read more

Edit links in PowerPoint using VBA

Edit links in PowerPoint using VBA

In a previous post, we considered how to link Excel files to PowerPoint presentations.  This can be a significant time saver as the PowerPoint presentation can be updated automatically.  Once you have created the links, life is brilliant, until . . . you need to change which file the PowerPoint presentation is linked to.  You … Read more

Linking Excel files to PowerPoint

Linking Excel files to PowerPoint

If you regularly create PowerPoint presentations that include information from Excel, you will know how frustrating it can be.  Having to re-copy and re-paste the information every time a change is made in the original Excel documents.  Have you come across the feature which enables you to link your Excel workbook directly into your PowerPoint … Read more

The fastest way to create Bullet Charts

Fastest way to create Bullet Charts

My first experience of Bullet Charts came from reading Information Dashboard Design by Stephen Few in 2007.  This was the year I started to get serious with dashboards. Initially, to create Bullet Charts I used the 3 stacked bar/column charts approach.  Later, I moved to using the two-axis stacked column where possible, but in general, … Read more

Advanced VLOOKUP Cheat Sheet

Advanced VLOOKUP Cheat Sheet

We have now reached the end of the Mastering VLOOKUP series.  Hopefully, you’ve picked up a few tips and tricks to take your VLOOKUP skills to the next level.  If you’ve been following along you will have learned more than just VLOOKUP: Download the Advanced VLOOKUP Cheat Sheet There is a lot to remember, so … Read more

VLOOKUP: List all the matching items

VLOOKUP list all matches

In the previous post in this series, Mastering VLOOKUP, we learned how to look up the 2nd, 3rd, 4th or nth item from a data set.  Today, we will be expanding on that by looking at how to return all the matching values in the dataset.  Plus, we will combine this with partial matches, so … Read more