1. Download the Practice File Temperature onto your local drive.

2. Double-click Temperature to open the temperature worksheet.

Formatting cells

You'll make a few modifications to the worksheet and then create a chart and insert it into a Word document.

1. Select cells A2 and A3.
2. Format the title text to Bold and Underlined, and change the Font Size to 14.
3. Change the Font Color to dark green.
4. Highlight cell B6:C6.
5. Right-click on cell C6 to show the formatting options.
   
   Tip: Make sure the pointer is over one of the highlighted cells when you click the right mouse button, or you will have to select the cells again.
   
   
6. In the shortcut menu, click Format Cells.
7. Click the Border tab.
8. In the Style box, click the Solid Double Line.
9. In the Border box, click the Bottom button.
10. Click OK.

Adding a formula

1. Click cell C7 and type the formula =9/5*b7+32
2. Press enter.
   
   Notice that the formula appears in the formula bar when the cell is selected. If you need to make a change to your formula, click in the formula bar to edit the formula, or double-click the cell where the formula resides and then click the green check mark or press enter to accept a change.
   
   
3. Click cell C7.
4. Use Autofill to copy the formula C7:C15.
   
   The conversion table is complete, and now you can create a chart.

Creating a new chart

1. Select cells B6 through C15.
2. Click the ChartWizard button.
3. For Chart Type, click Column for Chart Sub-Type, click the top Clustered Column.
4. Click Next.
5. Under Series In, click Columns.
6. Click Next.
7. Click the Titles tab.
8. In the Chart Title box, type Temperature Conversion Table.
9. In the Category(x) Axis box, type Centigrade.
10. In the Value(y) box, type Fahrenheit.
11. Click Next.
12. In Place Chart Area, click As Object In.
13. Click Finish.

Editing the chart

1. Right-click the numbers next to the vertical axis, then choose Format Axis in the submenu.
2. In the Format Axis dialog box, click the Scale tab.
3. For Maximum, type 150.
4. For Major Unit, type 50.
5. Click OK.

Your chart should look like this:



Save your chart

Save this worksheet and chart. If you want to keep the original file as you first found it, click Save As on the File menu and save it under a different name. Otherwise, click the Save button on the toolbar.

Finished chart to download

This is one of a number of ways to insert a chart into a Word document. Here you simply want to add this chart to an existing document.

1. Open Microsoft Word 97 (if it's not already open).
2. Create a new document.
3. Open the Excel 97 file "Temperature" (if it's not already open).
4. Click the Temperature Conversion chart in to select it.
5. Right-click the chart and then choose Copy.
6. Click the Word icon on the Windows 95 taskbar to switch to Microsoft Word 97.
7. Place the insertion point in the new document.
8. Press enter twice.
9. Right-click and choose Paste to copy the chart into the document.

In-place editing

1. If you want to make any changes to your chart now, you don't need to return to Excel. You can do your editing right where you are.
2. Double-click anywhere on the chart to activate the Excel 97 menu choices.
3. Click the title of the chart to select it.
4. Change the word Table to Chart, since that's what it really is.
5. Click anywhere outside the chart to return to the Word 97 menus and commands.

You now have a document with text created in Word 97 and a chart brought in from Excel 97. It would be just as easy to bring in a spreadsheet, a slide from PowerPoint 97, or a database entry and insert it into your document.

Close Word 97 and Excel 97, saving any files you want to use later.

By creating a compound document with information from Word  and Excel, you have used the power of these two programs to bring your ideas together. You learned how to:

On your own

Creating charts to explain complicated data and statistics can be a lot of fun, as well as adding interest and impact to your documents. It's the type of activity that requires practice and experimentation, though, since most of us have developed and used very few charts in the course of our work. You and your students can try some of the following activities to become more familiar with creating charts: