A lot of dashboard creators love the Camera Tool, it’s such an easy way to compile charts and tables from all over a workbook into a single view. However, there is one thing I dislike about the Camera Tool, and this one thing has kept me from using it more – the on-screen picture quality of the Camera Tool is quite poor. When the workbook is printed, it’s fine, but interactive dashboards have to be viewed on screen, so image quality is important.
But recently, I stumbled across something strange, which might just change my mind.
The Camera Tool picture quality problem
Take a close look at the images below. The “How do I look?” on the left (Original) is just plain text, the “How do I look?” on the right is the same text which has been through the Camera Tool. Can you tell the difference in the picture quality?
It may not be immediately obvious, but take a closer look. The image using the Camera Tool does not have the same image clarity. Below, is the same image zoomed in. Can you see what I mean? The difference is especially obvious on the curved letters (the “o” looks terrible, very pixelated).
I may be a bit picky, but this makes me not want to use the Camera Tool. A dashboard is a visual representation of data; therefore, I don’t want to use anything which overly degrades the quality of the visuals.
The Camera Tool picture quality solution . . . maybe?
Here is what I stumbled across, selecting a larger range appears to improve the image quality, so in this example, rather than selecting a Cell B4 (as I did for Image #1) , select Cells B4 – B34 before using Camera Tool. Image #2 below is using the much larger selection area Do you notice a difference now?
Here is the zoomed in image.
In Image #2, the text appears a little bit bolder than the original, but it is certainly less pixelated than Image #1. This is much more usable. To crop the oversized image down to right size, click the image, then select Picture Tools -> Format -> Crop from the Ribbon.
There you have it, by selecting a larger range the image quality improves. Why? No idea! Is this quality improvement enough . . . I think so.
Have you got a work around for this which gets crystal clear images? If so, please share, I would really like to know.
Get Excel news, tips & tricks straight to you inbox. Helping you to save time and achieve more with Excel.
You will also receive the Tab Hopper Add-in for FREE.