Page 285 - Excel Workbook for Dummies

29_798452 ch20.qxp 3/13/06 7:44 PM Page 268
268 Part VI: Excel and the Web

1. Choose File➪Save as Web Page to open the Save As dialog box and there select
the Selection: Sheet option button and the Add Interactivity check box before
you click the Publish button.
2. Make sure that Items on Employee Pivot List is selected in the Choose text box,
Pivot Table with PivotTable2 ($A$1:$G$13) is highlighted in the list box below,
and that the Add Interactivity check box and PivotTable Functionality in the
drop-down list box to its right are selected.
3. Select the Browse button to open the Publish As dialog box with the Chapter 20
folder selected and then replace Page.htm with Exercise 20-4.htm (be sure that
you retain the .htm filename extension) before you select OK.
4. In the Publish as Web Page dialog box, select the Open Published Web Page in
Browser check box and then select its Publish button.
After saving the data list in the Exercise20-4.htm Web page, the Internet Explorer
opens the PivotTable2 worksheet complete with toolbar in the new HTML
document.
5. Click the Field List button on the pivot table toolbar (the button immediately to
the left of the Help button with the question mark) to display the PivotTable
Field List dialog box and then use it to convert the Dept field from the table’s
column field to its row field.
Select the Dept field in list box in the PivotTable Field List dialog box and then
click the Add To button while Row Area is selected in the drop-down list box to
its immediate right.
6. In the interactive pivot table, drag the Location row heading to the area marked
Drop Column Fields Here to make the Location field the table’s sole column field.
7. Close the PivotTable Field List dialog box and then filter the pivot table by select-
ing M for the Gender page field and No for the Profit Sharing page field.
Deselect the (All) selection on the page field’s drop-down list before you select
the M or No check box followed by the OK button.
8. Close Internet Explorer and then the Exercise20-4.xls workbook in Excel without
saving your changes.

Web pages with interactive charts

When you create interactive Web pages with charts, your users can edit the support-
ing data that is automatically shown beneath the chart as an attached data table and
have the chart automatically updated on the page (see Chapter 14).

Try It

Exercise 20-5: Creating a Web Page with an Interactive Chart

Open the workbook Exercise20-5.xls in your Chapter 20 folder in the My Practice
Spreadsheets folder on your hard disk or in the Excel Workbook folder on the work-
book CD-ROM. This workbook contains a copy of the 2006 Production Schedule data
table with an embedded Clustered Column chart immediately beneath it. You will use
this embedded chart to practice creating a Web page with an interactive chart:

1. Choose File➪Save as Web Page to open the Save As dialog box and there select
the Selection: Sheet option button and the Add Interactivity check box before
you select the Publish button.