Objective 1. Insert and Link in Word an Excel Object

Activity 4.1. Inserting and Linking an Excel Object

In this activity you will add the Excel chart to the agenda page for the meeting. By selecting options in the Insert object dialog box, you can link your Word document to the Excel chart in another file.

1.

Start Word, and then Open the file Weekly_Sales_Chart from the folder that contains your project files. Save the file as Weekly_Sales_Chart_Firstname_Lastname

2.

In the document, position the insertion point below the heading Current Week Sales Chart.

You can change the screen display to see the chart position on the page more easily.

3.

On the Standard toolbar, click the Zoom arrow, and then click Whole Page.

4.

On the Insert menu, click Object. The Object dialog box displays.

5.

In the Object dialog box, click the Create from File tab, and then click Browse. The Browse dialog box opens.

The Excel file that contains the sales information you want to use is named Sales_Totals. It includes a chart sheet that shows the totals for the salespeople.

6.

In the Browse window, from the Look in list, select the folder that contains your project files, click the file Sales_Totals, and then click Insert. The path for the file displays in the File name box.


[Page 1377]

7.

Click the Link to file check box, and then click OK.

This creates the link to the Excel file and enables changes from the Excel document to update the Word document. The chart appears in the Word document, but it will extend beyond the edge of the page. Compare your screen with Figure 4.2.

Figure 4.2.


8.

Save your file.



[Page 1377 (continued)]

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