Celebrate 'The VLOOKUP Book' birthday with us. Last day to get 50% discount on the e-book (31 October only).

Click here for details

What is camera tool and how to use it? [spreadcheats]

Posted on December 2nd, 2008 in Charts and Graphs , Learn Excel - 33 comments

Camera tool is your way of creating visual reference in an excel sheet. It is one of the useful and hidden features of excel. Here is how it works. You specify a rectangular area in your workbook and camera tool creates a mirror image of that area as a drawing object. You can move it or resize it. And whenever the contents of original rectangular area changes (charts, drawings or cell values) the mirror image changes too.

How to add camera tool to standard toolbar?

In order to use camera tool, you must add the tool to a tool bar in excel menu area. Here is how you can do that:

  1. Go to menu > tools > customize
  2. In the dialog go to “Commands” tab and select “tools” in categories.
  3. Scroll down in the commands area until you see a little camera tool
  4. Now drag and drop this in your tool bar as shown below
  5. Adding Camera tool to Excel Toolbar

How to use excel camera tool?

Using Camera tool in MS Excel - How to and tutorial
We will use camera tool to create a micro-chart in excel.

  1. First make a normal chart.
  2. Now select the cells surrounding the chart
  3. Click on camera tool
  4. Now click any where in the worksheet and excel places a snapshot of the range you have selected
  5. Resize it until you get the microchart effect.
  6. Bingo !
  7. Btw, excel adds a border to the camera tool output. You can remove it by using drawing tool bar

Bonus tip: Alternatives to camera tool

Another alternative to camera tool is to use the image and indirect references technique we have learned in conditionally hide or show charts post.

Read earlier spreadcheats as well.

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

33 Responses to “What is camera tool and how to use it? [spreadcheats]”

  1. Dan says:

    In Excel 2003 you can also invoke the camera by copying the area you want to view, then hold the Shift key while you press the Edit menu. When you do that you get a “Paste Picture Link” option.

    When you show people that it can seem like magic.

  2. aerogeek says:

    Cool trick. Have never used it and tried it for the first time. Its neat!!!! Thanks!!!

  3. Stružák says:

    Nice feature. Thanks for sharing knowledge. :-)

  4. Chandoo says:

    @Dan… That is fantastic. I never knew about this wonderful way of getting camera snapshots. Thanks for letting us know about this :)

    @Aerogeek: you are welcome.

    @Struzak: Thanks and welcome to PHD blog :)

  5. Ketan says:

    You may use any shape or text box too and link the data of desired cell thru function bar. If you want to rotate the data with the rotation of the shape, need to apply same therapy as mentioned by Dan.

    Check it out !

  6. [...] range based references along with cell() formula to automate the whole thing. Oh yeah, they also use camera tool outputs to show you previous and next month calendar [...]

  7. [...] To create an instant micro-chart from your normal chart, use camera tool… Get Full Tip 62. Understand data to ink ratio to reduce chart junk, using even a pixel more of ink than what is [...]

  8. Megs says:

    Much better than the Camera command. That sounded great but when pasting 2nd shot, the 1st updates to the same. Result: 2 shots of the same thing!

  9. Chandoo says:

    @Megs.. I am not sure I got your question… Camera tool gives a live preview, so when the underlying range changes, the camera image too.

  10. [...] monthly calendars from January thru December. Each month’s calendar also includes a snapshot (uses camera tool) of the previous and next month’s calendar. You can also add up to 6 notes per each date in [...]

  11. MV says:

    Hi,
    Excelent site!!

    I`m using these technique with a graphic, but, I have two problems ( with Excel 2003):

    1.- The snapshot loose resolution when a resize to small size.
    2.- After I place the snapshot in the new location (other sheet), the plott area, always resize by itself, to the small size posibble.

    :(

    • Chandoo says:

      @MV… thank you and welcome to PHD.

      1. you should try to preserve the aspect ratio of the original range in the resized camera tool output to avoid poor fidelity.
      2. The plot area resize could be due to some other issue (like opening an excel 2007 chart in 2003). I have never experienced such an issue with camera tool outputs.

  12. Mani says:

    An extension to Dan’s idea,

    copy the cell values and paste special as link in power point (Paste Special > Paste Link > MS Excel Worksheet Object). The values in the power point will change when changed in excel. This can be used when dashboards have to be presented everyweek ( or everyday ?!) , but you are lazy enough to paste a snapshot from excel to powerpoint every time your presentation is due

  13. [...] picture links are not really new, they are called as camera snapshots in earlier versions. They provide a live snapshot of a range of cells to you in an image. So that [...]

  14. Fitriadi says:

    Hi, what an awesome site,
    It’s a bit late but, I encountered a problem with print preview. Every time I did that, the camera box will be resized to a small box, so it messed everything up. Do you know what can cause it?
    I read on another topic that it can be caused by printer driver, but so far i still having the same problem.
    Thanks

  15. jacqui says:

    hi this is interensting but i wondered

    does the camera tool exsist in excel 2010? or has it been superseeded by another command i woudl really love to try it out

    thanks very mcuh

    • Will B says:

      Slow reply sorry- it is still in 2010- you need to add it to the Quick Access Toolbar- look under all commands and it is listed as Camera.
      Thanks

      • Adrian says:

        You can copy and paste as a picture which does a better job as it doesn’t have the border around the graph.

  16. Chandrashekhar Joshi says:

    I think difference between using camera tool and copy-paste picture method is
     When you use camera tool your picture is dynamic and it changes if source changes.
    With Copy-paste method the picture is Static.
    Correct me if I am wrong.
    - Joshi
    P.S. Thanks Chandoo & Hui for sharing KNOWLEDGE

  17. Saran Kumar says:

    Nice post, Chandoo…
    The below is the basic difference among camera tool, Copy as picture – past
    e, copy as picture – bitmap – paste.
     
    1. Camera tool is like a mirror image as chandoo explains in the post. If you change the source data the image also changes.
    2. Copy as picture option displays image once you paste the data. This image is like a transparent image. You can able to see the data back side of the image.
    3. Copy as picture – Bitmap option displays image once you paste the data. This image is not transparent. Means, you can not able to see the data back side of the image.
    Camera tool is so useful when you are doing auditing. You can create interactive images also with camera tool. http://lostinexcel.blogspot.in/2012/08/How-to-make-interactive-images-in-ms-excel-camera-option-vlookup-indirect-formula-data-validation-define-name.html
     
    Regards,
    Saran
    http://www.lostinexcel.blogspot.com

  18. S5 says:

    Hi Everyone,

    This is mentioned as an alternative the image hack which can be used to create dropdown menu and return different images eg. 3 different charts from another hidden sheet.

    The Camera tool seems cool but I don’t understand how I would use it in practice?  Could someone explain a useful example for this tool please?  ps I am an MI Reporting Analyst.

    Thanks

  19. LB says:

    Agreed that Camera tool is VERY USEFUL…however, sometimes run into the following issue and wonder if anyone knows how to address (or if there is a way to address):

    How can you embed the Camera shot within the chart so Camera shot is included as you move the chart around, copy/paste the chart and/or print the chart itself (rather having to print the page)?

  20. Hani says:

    Is there a keyboard shortcut for using Camera?

  21. [...] Categories: Features I recently discovered the camera tool when I was going through a blog by ChandooSome of us might not know about this feature as it is not directly accessible in the tabs of excel, [...]

  22. Ramesh says:

    Dear Chandoo,
    For quite some time i am visiting your site to learn some excel tricks and to get solution to the problems I face at work. And this one also helped me to get some insight on how to use camera to paste picture as link… Thank a lot… and hope to see some more of this kind….

  23. [...] I recently discovered the camera tool when I was going through a blog by Chandoo. [...]

  24. […] Can be done with the 'Camera Tool' in Excel. link: What is Excel Camera tool and how to use it? [MS Excel Tutorial] | Chandoo.org – Learn Microsoft Exc… […]

  25. […] Try the Camera Tool: example What is Excel Camera tool and how to use it? [MS Excel Tutorial] | Chandoo.org – Learn Microsoft Exc… […]

  26. banadara says:

    This is very useful tool in Excel.
    Thanks

  27. anwar says:

    Is there any way to prevent excel from resizing the camera image if someone double clicks on it?
    Thanks

Leave a Reply