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 |
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. |
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 |
6. |
Save |
7. |
Right-click the sheet tab and click Select All Sheets. Then, on the Standard toolbar, click the Print button |
8. |
If you printed your formulas, be sure to redisplay the worksheet by pressing |
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