Microsoft Office Tutorials and References
In Depth Information
Suppose you want to interchange the figures in columns B and D.
You would copy the range B12:B14 to cell D17 (which also copies
the chart), delete the chart shown in column B, copy the range
D12:D14 to cell B12, delete the chart in the range D12:D14, and
then copy the range D17:D19 to D12.
Expand or Contract the Figures
When you first create your charts and tables, you only can estimate
their final size. Not until all the other figures are in place can you
really see which figures need more space, and which figures can
use less space. Therefore, you’ll typically need to expand and
contract the figures to make them fit on the page.
Before you expand or contract figures, you need to ensure that their
properties are set correctly. Specifically, your charts must be set so
they move and size with cells, but the Camera objects must be set
so they only move with cells.
To set up the chart objects, first select them all. To do this, select
one chart object, hold down your Shift key, and then click on each
of the other chart objects. To adjust the charts, right-click on any
selected chart; choose Format Object; then, in the Properties tab,
choose “Move and size with cells.”
To set up the Camera figures, select them all as you selected the
chart objects. In the Properties tab of the Format Picture dialog,
choose “Move but don’t size with cells.”
Now, to adjust the width of the charts, select each of the main chart
columns (columns B and D in Figure 8-8), and then set the same
new width for each chart in one operation. To adjust the rows,
select each main chart row and set the row heights in one
To adjust the Camera figures, you don’t adjust the camera objects;
doing so merely stretches or shrinks them. Instead, adjust the rows