Search Not Just Numbers

Loading...

Tuesday, 11 November 2014

Excel Tip: The Camera Tool - using parts of your spreadsheet in graphics or charts

This week, I just have a short post about a simple tool that is a bit of a hidden gem in Excel.

We know we can add graphics to an Excel spreadsheet by using the Insert ribbon to add images and shapes, as well as the many charts that we can create in Excel.

But what about when, instead of adding a bit of graphics to a spreadsheet, we want to add a bit of a spreadsheet to some graphics?

This might be having a table appear within the area of a chart, or in front of an image, for example.

We can do this easily using the Camera tool.

Before we can do anything, we need to make the camera tool accessible. Microsoft don't make it easy to find!

To do this we need to add it to a ribbon. We can do this as follows:

  • Select File, Options and Customize Ribbon
  • From the "Choose commands from:" drop-down, select "All commands"
  • Scroll down to find "Camera" (they're alphabetical)
  • Highlight any custom tab on the right hand side (the simplest is Home, Custom Edit)
  • Click "Add>>"
  • Click "OK"
You will now see this at the right hand end of the home ribbon.

Now we have the tool, it is really easy to use.

Say we have a small table in cells B3:D5 that we want to use within a chart, in front of an image, or within a set of shapes.

All we have to do is select cells B3:D5 and click the Camera Tool. The cursor turns into the same cross hairs you see when creating a shape, but this time you can draw the shape within your graphics (which don't have to be on the same sheet as the original table), and the result becomes an object (just like the shapes) that you can manipulate in the same way.

It's that simple!



If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".

5 comments:

  1. It is a very useful tool as the values in the photo image update as the sheet values change
    I use it to play “what-if-scenarios” with Clients
    Paste a photo of the Results summary from a different sheet on the working sheet and change the working sheet parameters / values and the results to the Results summary can instantly be seen

    I also use it to paste remarks like "DRAFT" across the spreadsheet
    Type “DRAFT” (or any other note) into a remote cell, light colour the background, take a photo and paste it over a spreadsheet
    The position, size and inclination can be adjusted
    Should the image be in the way when reviewing the spread sheet it can easily be moved to allow sighting of all cells
    Fred

    ReplyDelete
    Replies
    1. They're two great uses of the tool Fred. It's bizarre how Microsoft almost hides it from users!

      Delete
  2. I am a regular reader of your “Not Just Numbers” blog post and I appreciate your efforts...thank you!

    Your recent post on the use of the Excel camera interested me as I too tend to use the camera in some of my work. Hence I have given you the following link to a short post that recently wrote regarding one unique (camera) application that I find useful and helpful.

    http://cfadvisorsllc.com/the-wyn-blog/entry/use-your-excel-camera-with-your-excel-dashboard-to-give-you-clarity-and-focus

    I hope that you find it interesting.

    ReplyDelete
  3. But here's the deal. Artificial trees are dior replica made from nonrenewable petroleum, and are dior replica often shipped halfway around the world - substantially deepening your carbon hermes replica footprint. Most factory sites for fake trees are based in China, where 85 percent of those sold tag heuer replica in North America originate.

    ReplyDelete
  4. It was right after the 2nd Planet War that the idea of louis vuitton replica handbags seamed nylon stocking attracted the focus of the higher element of the market. This was mostly due to the fact the female segment of the society was much more conservative about dress and perform. With gorgeous extended skirts, they favored to dress in seamed nylon stockings as element of the fashion.Stitching: Newer model CD handbags need to have the stitching on the label cover all four sides of the label. Meaning the stitching must act as a frame for the label. A lot of replica belts the fake Dior handbags have the stitch lines running only along the prime of the label. Nonetheless, for older vintage bags, (prior to 1990-92), the leather label will be stitched across the prime only. This distinction is crucial amongst the outdated and the new.Ambani is another Indian who has been diligently developing his inherited fortune, this time in the replica louis vuitton petrochemical market. He increased his fortune by practically $10 billion in 2009, catapulting him from #7 to #4.The Fendi handbags lovers should know normally the Fendi bags in low cost for out of vogue and defect. That is to say please do not search for the price reduction Fendi handbag in authorized merchants. Try yet another way, such as the louis vuitton replica uk foreign trade plant. Usually speaking, in the manufacture procedure, there are constantly some defective handbags. Of program the leading brand companies like Fendi will not admit this variety of handbag to be sold in its shop. But if you do not care about these small defects, why not go to these factories and personal it in decrease price? Getting the low cost Fendi replica handbags on the internet stores is also an excellent way! Some old-fashion handbag will be off the shelves and the price tag could be a little shock.

    ReplyDelete