This post may contain affiliate links. Please read my disclosure for more info.

Solving the Camera Tool image quality problem?

Camera Tool image problem thumb

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?

Camera Tool Pixelation

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 in the curved letters (the “o” looks terrible, very pixelated).

Camera Tool Pixelation

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?

Camera Tool Pixelation

Here is the zoomed in image.

Camera Tool Pixelation


In Image #2, the text appears a little 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.


Other solutions?

Have you got a workaround for this which gets crystal clear images? If so, please share, I would really like to know.

Want to Learn VBA & Macros?

If you want to automate Excel and save time, my recommended resouces for learning VBA Macros are: