Is there a solution? Yes - the little known Excel Camera Tool allows you to take a picture of any section of a spreadsheet and place it on your dashboard at whatever size and shape you need. The key difference is that although you can manipulate it like an image it’s a “live picture” – anytime the underlying data changes the values in the picture automatically change too.
The camera tool is not automatically enabled on the Excel menu in the latest versions of excel but it very easy to add it by selecting “Customise the Quick Access Toolbar”. So if you are building excel dashboards and you don’t know about the excel camera tool you are definitely missing an important trick!