Microsoft Office Tutorials and References
In Depth Information
Step 8: Make It All Fit.
When you compare Figures 8-1 and 8-2 you’ll see that I had to
change my Report sheet as I moved from the mockup to the final
design. This is because the financial statements took up more
space than I had estimated and I had forgotten the Legend entirely.
This is a common problem. Your figures seldom fit exactly as
planned. Or your mockup might overlook a critical figure that must
be added to your report. Or when your boss sees the “final” version,
he immediately asks for changes. Or whatever.
In other words, it’s a good idea to know how to adjust your figures
to make them fit in the room available.
Create a Parking Place
After you set up a chart
figure you’ll often need to
move it within the display.
This often means that you
must park one or more
figures out of the way so
you can move another
figure into position.
The easiest way to do this
is to copy several
spreadsheet rows that
contain one row of figures,
and then paste them
below your display. When
you copy the entire rows,
Excel sets the height of the target rows to the height of the source
rows. Then you delete the copied chart objects. Here, for example,
I copied rows 12 through 14 to cell A17, and then I deleted the
copied charts to create a parking place.
Figure 8-8. Rows 17-19, which are below the
actual dashboard, have been set up to "park"
chart figures so they can be repositioned.