into this without needing PowerPoint or Word etc: Even better, when you adjust the original data, the “picture” taken with the camera, also updates!
The spreadsheet containing the data we’ll be using can be downloaded here.
Step 1: Show the camera tool on the ribbon
- Click on File > Options > Customize Ribbon.
- In the dialog box that appears (above), click on the drop down box in the top left hand corner to Choose commands from “Commands not in the ribbon”
- The list will be in alphabetical order.
- Scroll down until you can see the Camera tool (if it is not visible already).
- Since the command is not currently in the ribbon, we need to create a customized tab and group. Click on the New Tab button at the bottom right.
- Then click on the New Group button.
- You can rename each as you wish. My new tab is called “Tools” and my group “Camera”.
- Drag and drop the Camera command below the newly created group.
- Press the OK button.
- The ribbon should update automatically.
Step 2: Create the Camera Image
- Create your data table and / or graph / chart etc.
- Select the cells containing the data or chart you wish to create the image from. Note: You cannot use the camera tool directly on graphs, only on the cells behind them. This is why I have selected cells E1:L15 as shown below.
- Click on the camera tool on the ribbon.
- Draw the shape (by left clicking and dragging the cursor across the screen) where you want the camera image to appear. It automatically creates a square shape, but this is adjusted automatically based on the shape of the cells you have selected.
- The image will appear once you let go of the left mouse button.
Step 3: Format the image
- Click on the camera image and the picture toolbar will appear.
- You can choose one of the presets, or press Ctrl+1 and format the image as you wish.