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