Microsoft Office Tutorials and References
In Depth Information
Using Excel’s Camera Tool
Enhancing a dashboard with the Camera tool
Here are a few ways to go beyond the basics and use the Camera tool to enhance your dashboards
➤ Consolidate varied ranges from different sources into one print area.
➤ Rotate objects to simplify your work.
➤ Create small charts.
Consolidating disparate ranges into one print area
Sometimes a data model gets so complex that it’s difficult to keep all the final data in one printable
area. This often forces the printing of multiple pages that are inconsistent in layout and size. Given
that dashboards are most effective when contained in a compact area that can be printed in a page
or two, complex data models prove to be problematic when it comes to layout and design.
When you create pictures with the Camera tool, you can resize and move the pictures around freely.
This gives you the freedom to test different layouts without needing to work on column widths,
hidden rows, or other such nonsense. In short, you can create and manage multiple analyses on
different tabs and then bring all your presentation pieces together in a nicely formatted presentation
layer; see Figure 4-39.
Figure 4-39: Use the Camera tool to get multiple source ranges into a compact area.
Rotating objects to save time
Again, because the Camera tool outputs pictures, you can rotate the pictures in situations where
placing the copied range on its side can help save time. A great example is a chart. Certain charts
are relatively easy to create in a vertical orientation but extremely difficult to create in a horizontal