3 ways to change or insert images based cell values

From stock parts to holiday villas, from employees to logos, there are plenty of reasons to insert and automatically change an image based on a cell value.  Or you may think if this a formula which changes a picture, rather than a number.  Ultimately, the purpose is to link an image or picture to a Read More

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