Chapter 23: Visualizing with Custom Number Formats and Shapes
23
FIGURE 23.21
Pasting a linked picture
Linked pictures give you the freedom to test different layouts and chart sizes without the
need to work around column widths, hidden rows, or other such nonsense. In addition,
linked pictures have access to the Picture Tools formatting options. When you click on a
linked picture, you can go to the Picture Tools contextual tab and play around with the
picture styles there.
Figure 23.22 illustrates two linked pictures displaying the contents of the ranges on the
left. As those ranges change, the linked pictures on the right will update. These can be
moved, resized, and even placed on a completely different sheet.