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!
