home   Java Script   MS Access   Perl   HTML   Delphi   C ++   Visual Basic   Java   CGIPerl   MS Excel   Front Page 98   Windows 98   Ms Word   Builder   PHP   Assembler     Link to us   Links    


Putting It All Together with Excel 97

What you will learn from this lesson

With Excel 97 you will:

 

What you should do before you start this lesson

Before you start this lesson, you need to:
  1. Start Excel 97.
  2. Start Word 97.

    3.  

    Exploring the lesson

    Throughout this book you have been building one skill upon another. Each step has been leading you to complete a formal report complete with charts and graphs. This chapter will use data and graphs you made in an earlier lesson and saved to the file named Technology.

    Creating linked data charts

    Data from a worksheet can be linked into a Word document. Every time the numbers in the worksheet change, the corresponding numbers in the Word document will be updated.

    Linking data charts into a Word document

  3. Open the Word document that you want to use for your report.
  4. Open the Excel 97 worksheet named Technology, which you saved earlier.
  5. Select the area of the worksheet to be copied into the Word document.
  6. Press ctrl+c.
    – or –
    On the Standard toolbar, click the Copy button.
  7. Click in your Word document where you want to insert the data table, graphic, and WordArt title.
  8. On the Edit menu, click Paste Special.
  9. Click Paste link, Microsoft Excel Worksheet Object, and Float over text.
  10. Click OK, and save your Word 97 document.

Your data chart, graphic, and WordArt are now part of your document. This method of linking the data chart to your document uses the least amount of system memory. Any changes you make in the Excel 97 worksheet will be reflected in your Word document.

Creating linked graphs

Linking a graph from Excel 97 is an easy way to ensure that any changes to your graph in Excel 97 are carried over to your graph in a Word 97 document.

Linking a graph
  1. Using the same Word document you used in the previous lesson, click the location in that Word document where you want to insert your graph.
  2. Click the graph tab at the bottom of the Excel 97 screen to select the colorful graph. (Sheet1 contains the actual data. If you made several graphs, confirm which one is saved under which general name.)
  3. Click the outside edge of the graph to select it. Sizing handles will appear, marking the graph corners and side boundaries. They can be grabbed to move or change the size of the graphic.
  4. On the Standard toolbar, click the Copy button, or press ctrl+c. A moving dotted line will outline your graph.
  5. On the Edit menu, click Paste Special.
  6. Click Paste Link and Float over text, and then click OK, just as in the previous exercise.
  7. Size your graph, and move it into position in your document.
  8. Save the Word document and the Excel workbook, and close the documents.

Excel 97 has linked your chart and graphic from your worksheet to your document. You can edit through Word 97 into Excel 97, but it may be slower than entering the changes directly in Excel 97, depending on your computer speed and system memory.

 

How you can use what you learned

You can easily insert Excel data charts and graphs into any Word document. The next time you calculate your grades, insert the data table and graph into your document. Any changes you make to the Excel worksheet will be automatically updated in your Word document.

Your monthly reports can be updated as quickly as you change the data. In letters to your students’ parents, you can quickly update the scores and grades.

 

Extensions

With the Excel 97 wizards, try using other chart types to view your data. Sometimes data has no recognizable pattern in one chart type but gains high impact when displayed through a different chart. If you change just a few of the chart characteristics, you may gain a different perspective of the data.

Using Excel 97 to link data tables and graphs to your Word documents adds excitement and drama to your reports, letters, and presentations. You and your students can benefit from using clear and concise graphs in your reports, letters, and presentations.

 

Summarizing what you learned

In this chapter you have explored and practiced: