Camera shape, as the name suggests, is a mirror image of a referenced area in a spreadsheet. It is a dynamic image, meaning that any change in the referenced region is reflected in the image as well.
Camera shapes can be moved, resized, rotated, and supported for Excel I/O. They can also be grouped or ungrouped with other shapes and copy-pasted from one sheet to another.
In Excel-like Tables, camera shape does not capture any pictures, shapes, or charts present in the specified cell range
It does not support text editing, text formatting, or adjustment capabilities
When a camera shape containing a picture, shape, or chart is exported to Excel, the Excel-like Tables unsupported objects (pictures, shapes, or charts) are displayed in Excel.
Consider an example where the sales data of different products across a supermarket is maintained to analyze the sales trends. The data for different product categories like Fruits, Vegetables, Bakery, Meat, etc. are maintained in different worksheets of a spreadsheet.
The summarized monthly sales data is displayed on a consolidated 'Dashboard' worksheet which shows camera shapes for the products' sales across different product categories. Any change made to the sales data is reflected in the 'Dashboard' sheet as well.