Page 63 - Excel Workbook for Dummies

07_798452 ch03.qxp 3/13/06 7:38 PM Page 46
46 Part I: Creating Spreadsheets

7. If you have access to a printer, print this two-page report; otherwise, just close
the Print Preview window and then save the workbook as Solved3-7.xls in the
Chapter 3 folder inside your My Practice Spreadsheets folder before you close
the workbook.

Printing charts in the spreadsheet

Charts that you create from the data in your spreadsheets are either embedded in the
same worksheet that contains the data or on a separate Chart sheet (see Chapter 14).
In Exercise 3-6, you saw that embedded charts are printed as part of the worksheet
unless you select just the data ranges they’re created from as the print selection. In
Exercise 3-7, you saw that charts placed on their own Chart sheets are not printed
unless you select their sheets as part of the print selection.

What you didn’t see is that when you print a chart placed on its own Chart sheet,
Excel adds a Chart tab to the Page Setup dialog box. The Chart tab contains options
for scaling the chart instead of printing it full page and for printing the chart in black
and white instead of color. You get experience using these options in Exercise 3-8 that
follows.

Try It

Exercise 3-8: Printing a Chart in a Report

Open the Exercise3-8.xls workbook in the Chapter 3 folder in your My Spreadsheets (or
My Practice Spreadsheets) folder or on the workbook CD-ROM and use this copy of
the 2006 Production Schedule workbook to practice printing a chart saved on its own
Chart sheet in a workbook:
1. Select the Column Chart sheet in the Exercise3-8.xls workbook and then open the
Page Setup dialog box.
2. Change the Printed Chart Size option from Full Page to Scale to Fit Page and
select black-and-white printing for the Printing Quality. Next open the chart in
the Print Preview window.

3. Display the margin markers in the Print Preview window and then add a header
with the sheet name centered in the top margin and the current page number in
bottom margin.
4. Close the Print Preview window and return to the Column Chart sheet in the
Exercise3-8.xls workbook.
5. If you have access to a printer, click the Print button on the Standard toolbar to
print this Chart sheet; otherwise, just make the Schedule sheet active before you
save the workbook as Solved3-8.xls in the Chapter 3 folder in your My Practice
Spreadsheets folder, and then close the workbook.

Printing the spreadsheet formulas

When you print a worksheet, Excel prints the entries exactly as they appear in their cells
of the worksheet. As a result, when you print a section of a worksheet that contains for-
mulas, the printout shows only the results of the calculations performed by the formulas,
not the contents of the formulas themselves. In addition to a printout showing the results,
you may also want to print a copy of the worksheet showing the formulas by which these
results were derived. You can then use this printout of the formulas when double-checking
the formulas in the worksheet to make sure that they are designed correctly.