Objective 9. Print a Chart on a Separate Worksheet

When you place a chart on a separate sheet, as opposed to embedding it in the worksheet as you did in Chapter One, the chart will print on a separate page. Page setup for charts that are created on separate worksheets is done independently from page setup for the other worksheets.

Activity 2.16. Printing the Worksheet and the Chart

1.

Use the sheet tab navigation buttons if necessary to display the Inventory Data sheet tab, and then click to make it the active sheet. From the File menu, display the Page Setup dialog box, and then click the Page tab. Under Orientation, confirm that the Portrait option is selected. On the Margins tab, center the sheet Horizontally.
 

   

2.

On the Header/Footer tab, create a Custom Footer in the Left section containing the File name . In the displayed Footer dialog box, click OK, and then in the displayed Page Setup dialog box, click the Print Preview button. Confirm that the data is centered horizontally and that the file name displays in the footer. On the Print Preview toolbar, click Close.
 


3.

Click the Percent of Retail Value Chart sheet tab. Display the Page Setup dialog box, and on the Page tab, confirm that the Landscape orientation is selected.

The default orientation for charts placed on a separate sheet is Landscape.
 

4.

Click the Margins tab. Notice under Center on page, both options are gray to indicate that the chart is already centered horizontally and vertically and these choices do not apply.
 

5.

On the Header/Footer tab, create a Custom Footer in the Left section containing the File name . In the displayed Footer dialog box, click OK. In the displayed Page Setup dialog box, click the Print Preview button. Confirm that the file name displays in the footer. In the Print Preview toolbar, click Close.
 

6.

Save your workbook. Check your Chapter Assignment Sheet or Course Syllabus, or consult your instructor, to determine if you are to submit your assignments on paper or electronically using your college's course information management system. To submit electronically, go to Step 8, and then follow the instructions provided by your instructor.
 

7.

Right-click the sheet tab and click Select All Sheets. Then, on the Standard toolbar, click the Print button . If you have been instructed to print the formulas from the Inventory Data worksheet, refer to Activity 1.17 in Chapter One to do so.
 

8.

If you printed your formulas, be sure to redisplay the worksheet by pressing . From the File menu, click Close. If the Microsoft Excel dialog box displays asking if you want to save changes, click No so that you do not save the changes to Print Setup that you used for printing formulas. Close Excel.
 

End

You have completed Project 2B



Project 2C Population Growth

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents



Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net