From the Not Just Numbers blog:

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”.