Saving Pivot Table Report and Pivot Chart Report as a Web Page

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Check out Appendix D on using Microsoft Office web components. By publishing a PivotTable report or PivotTable chart as a web page, you can work with your PivotTable or PivotChart interactively inside Microsoft Internet Explorer. When you select the PivotTable report, Excel uses the Microsoft PivotTable web component to publish your data. When you save your PivotChart report as a web page, the publishing job is handled by the Microsoft Chart web component. To manually save your PivotTable report and PivotChart report as a web page, perform the following tasks (for programming examples, see Appendix D):

1. Select the sheet containing the PivotTable report (see Figure A-10).

3. In the Save As dialog box, choose Web Page (*.htm; *.html) from the Save as file type drop-down list. Make sure the Selection: Sheet option button is selected. Click the Add interactivity check box. At this point, the name of the file changes to PivotCharts.htm.

4. Click the Publish button.

5. In the Publish as Web Page dialog box, select PivotTable from items on Sheet1 (see Figure A-12).

6. Click Publish.

The page should now open in your browser (see Figure A-13).

Publish as Web Page

Item to publish Choose:

Items on Sheet 1

d

Sheet

All contents of Sheet 1

M

Add interactivity with: IPivotTable functionality

Viewing options

Add interactivity with: IPivotTable functionality a

Pivot, filter, and sort data in Microsoft Internet Explorer 4.01 or greater.

Publish as Title:

Filename: |C:\APPEN\PivotCharts.htm'

AutoRepublish every time this workbook is saved

© ^ Open published web page in browser Publish

Figure A-12: Publishing a PivotTable report as a web page

*1 a

Fie £efc Mew Favcrtei Tmb hteip I 4* Back * - HmS '^search ngFiwarlei 0Hrtj»y ¿¡J -

a Q

;! ur^ B (J

Add-C&s C^APPENlPbOtChatSihtm

J

-

ffl % | S* .a If >- . m vlH; ^m

I ! ^

ProiluclNaine T

Tafti

Anna bodsworth

Jane! Leverling

Laura Callahan

Margaret Peacock

Michael Su/ama Nancy Davolio

Country T

Sum of ExlendedPrice

Sum ofEtfendedPrice

Sum of ExtendedPrice|Surn of EtfendedPrice; Sum of trrtendedPrice; Sum ai-rtendedPn

Argentina

223.2

Austria

217.39

651

Brazil

279

Finland

98.81

334 B

France

348 75

Germany

¿BB 25

331 31

1G7 4 1Gi

Ireland

1G27 5

Mexico

59.75

Sweden

3

USA

279

620 77 606

Grand Total-

96.81

571.95

1040 44

1331.06

2694 67 1147

H

«1 1

!*] Pens

y3(r«ty cnmpifc

Figure A-13: A PivotTable report published from Excel as a web page is displayed in Internet Explorer using the PivotTable Office web component. Office web components are covered in Appendix D.

A PivotTable report and a PivotChart report can be published together by saving the chart sheet as a web page.

1. Select the Sales Comparison chart sheet containing the PivotChart report (see Figure A-11).

3. In the Save As dialog box, choose Web Page (*.htm; *.html) from the Save as file type drop-down list. Make sure the Selection: Chart option button is selected. Click the Add interactivity check box. At this point, the name of the file changes to PivotCharts.htm. Change the filename to PivotCharts2.htm.

4. Click the Publish button.

5. In the Publish as Web Page dialog box, the Chart item is automatically selected (see Figure A-14).

6. Click Publish.

7. The web page should now open in your browser (see Figure A-15).

Note: To browse a web page interactively with the Office web components, you must have a Microsoft Office 2000/XP license.

Figure A-14: You can publish a PivotChart report as a web page.

Figure A-15: When you publish a PivotChart report from Excel as a web page, the browser uses the Microsoft Office web chart component to graph the data and allow you to interact with the chart. Also, presented on the same page (inside the Microsoft Office PivotReport component) is the source data for the ChartReport.

Was this article helpful?

0 0

Responses

Post a comment