PUBLISHING WITHOUT INTERACTIVITY: PREPARING THE EXCEL FILE in Font

Drawer PDF417 in Font PUBLISHING WITHOUT INTERACTIVITY: PREPARING THE EXCEL FILE

Figure 10-2. Blurred text in a published PivotChart on the chart sheet If possible, move the chart to a regular worksheet, and publish it there. The text quality will be better (see Figure 10-3), and you can easily adjust the size of the chart so it fits on the web page.

Figure 10-3. Clear text in a published PivotChart embedded on the worksheet, with the PivotChart fields hidden

Previewing the Web Page After preparing the workbook, PivotTable report, or PivotChart report, you can see how it will look on a web page. This technique displays the entire workbook as a web page, with interactive tabs that allow you to view any sheet. If your PivotTable report or PivotTable report is on a worksheet with other data, that data will also be included in the preview. When saving the file as a web page, you can specify which regions you want to publish.

1. Select any cell in the workbook. 2. Choose File Web Page Preview. 3. Your default web browser will open, with the active sheet in the workbook displayed. 4. If sheet tabs are visible, you can click them to view other sheets. 5. Close the web browser program, and make any adjustments required to the Excel file before publishing.

Publishing the Web Page After you prepare and preview the web page, you can publish it without interactivity by choosing File Save as Web Page. For detailed instructions, see Excel s Help.

You ve been asked to publish your pivot chart and pivot table on the company website, so visitors can change the layout and select items from the pivot field dropdown lists.

If you publish a pivot table or pivot chart with interactivity, visitors will be able to make changes to the pivot table and pivot chart on the web page, such as adding and removing fields and creating formulas. Office Web Components (OWCs) are created in the HTML file, based on the objects in the Excel file. These will look different than the Excel objects, and have different functionality. Prepare the pivot table and pivot chart to optimize the components that will be created on the web page.

Note If you publish the entire workbook with interactivity, charts won t be included, and PivotTable

Preparing the PivotTable Report 1. Most formatting will be lost when you publish a pivot table with interactivity. However, number formatting will be retained if you use the PivotTable Field settings dialog box, instead of selecting cells in the pivot table to format. To do this, right-click on a pivot table cell, and choose Field Settings. 2. If the worksheet that contains the pivot table or pivot chart is protected, remove the password if one is used. Password-protected sheets can t be published as web pages.

Preparing the PivotChart Report 1. Select a chart type and subtype that best presents the data. Visitors won t be able to change the chart type. The Cone, Cylinder, and Pyramid chart types will be changed to Column charts in the web page. Charts with a Surface chart type will not be loaded on the web page. 2. If there s a data table on the chart, it won t appear in the published pivot chart. You can add value labels to the chart series to display the values, or remind visitors that values will be displayed when they point to a data point on the chart.

Publishing the Web Page To create an HTML file from your PivotChart and PivotTable report that can be published on a website with interactivity, follow these steps: 1. Select any cell in the workbook. 2. Choose File Save As Web Page. 3. Select the directory in which you want to store the HTML file. 4. Click the Publish button to open the Publish as Web Page dialog box. 5. Under Item to publish, from the Choose dropdown, select Items on [Name of sheet that contains the PivotChart report]. 6. In the list of items, select your PivotChart report.