Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

You can create a Spreadsheet Component, PivotTable Component, or Chart Component from scratch by using a graphical Web-page development application such as Microsoft FrontPage. (Version 2000 or a later version of FrontPage is required.) To create an Office Web Component in FrontPage, follow these steps:

1. Start FrontPage.

2. On the File menu, point to New and then click Page Or Web.

3. In the New Page Or Web task pane, click Blank Page.

4. On the Insert menu, click Web Component. The Insert Web Component dialog box appears.

5. In the Component Type list, click Spreadsheets And Charts.

6. In the Choose A Control list, click Office Spreadsheet, Office PivotTable, or Office Chart, and then click Finish.

   Once you’ve inserted the component you need, you can connect the component to a data source or enter data from scratch. You’ll learn how to perform these steps later in the chapter.

7. Save and view the file.

   Note

   In FrontPage 2000, neither the task pane nor the Insert Web Component dialog box are available, but the steps are basically the same.