If you want students or other individuals to be able to interact with the data on a Web page, you can make the data interactive. Depending on the choices you make, people can perform such actions as filtering, entering new values for calculations, or summarizing and analyzing data in a PivotTable list.

For example, you can save a mortgage calculator with worksheet functionality to the Web so that students can use it to calculate how changing the term or interest rate will effect the monthly payment. Or, if you want to collect data from students in other parts of the world, they can enter data in an interactive worksheet.

INTERACTIVE AND NON-INTERACTIVE EXCEL 2000 DATA

Much of the data in Excel 2000 can be saved with interactivity, but some data must be saved to the Web without interactivity.

Data That Can Be Interactive

**PivotTable report

**Results of a query (external data range)

**Range of cells or a simple list

**Filtered list

**Chart

**Modified data on an interactive Web page that was previously saved by Excel

Data That Cannot Be Non-Interactive

**Entire workbook

**Modified data on a non-interactive Web page that was previously saved by Excel

PUT A CHART ON A WEB PAGE

Use this procedure to put a chart on a Web page so that others can interact with the data. You can also put a chart on a Web page so that others can only view the data. When you save an interactive chart to the Web, you must keep the following in mind:

*The associated data for the chart is also displayed on the Web page when you use interactive functionality. When you save a chart, the associated interactive worksheet is displayed and when you save a PivotChart report, the associated PivotTable list is displayed.

*Some formatting and features for the chart are not retained when you save it as a Web page.

*After you save the chart as a Web page, you can't open and modify the .htm file in Excel without losing formatting and functionality. Use Microsoft FrontPage 2000 or Microsoft Access 2000 to edit the Web page.

SAVE A CHART INTERACTIVELY ON A WEB PAGE

1. Click the chart or the chart sheet that you want to put on a Web page.

2. On the File menu, click Save as Web Page.

3. Click Publish.

4. Under Viewing options, select the Add interactivity with check box. (Chart functionality is automatically selected.)

5. To add a title to the chart, click Change, type the title you want, and then click OK.

6. In the File name box, click Browse and locate the drive, folder, Web server, or FTP location where you want to save your chart.

7. If you want to view the Web page in your browser after you save it, select the Open published Web page in browser check box.

8. Click Publish.