10.2 PUBLISHING WITHOUT INTERACTIVITY: PREPARING THE EXCEL FILE
Encoding PDF417 In None
Using Barcode creator for Font Control to generate, create PDF 417 image in Font applications.www.OnBarcode.com
Code 39 Encoder In None
Using Barcode creator for Font Control to generate, create Code39 image in Font applications.www.OnBarcode.com
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.
PDF-417 2d Barcode Maker In None
Using Barcode drawer for Font Control to generate, create PDF-417 2d barcode image in Font applications.www.OnBarcode.com
GS1 - 13 Printer In None
Using Barcode drawer for Font Control to generate, create GS1 - 13 image in Font applications.www.OnBarcode.com
Figure 10-3. Clear text in a published PivotChart embedded on the worksheet, with the PivotChart fields hidden
Barcode Drawer In None
Using Barcode creation for Font Control to generate, create Barcode image in Font applications.www.OnBarcode.com
UCC - 12 Generator In None
Using Barcode generation for Font Control to generate, create UPC-A Supplement 2 image in Font applications.www.OnBarcode.com
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.
Print Barcode In None
Using Barcode drawer for Font Control to generate, create Barcode image in Font applications.www.OnBarcode.com
Painting Delivery Point Barcode (DPBC) In None
Using Barcode maker for Font Control to generate, create Delivery Point Barcode (DPBC) image in Font applications.www.OnBarcode.com
10.3 PUBLISHING WITH INTERACTIVITY: PIVOT CHARTS AND PIVOT TABLES
Scan PDF 417 In None
Using Barcode scanner for Software Control to read, scan read, scan image in Software applications.www.OnBarcode.com
PDF 417 Generator In None
Using Barcode printer for Microsoft Excel Control to generate, create PDF417 image in Excel applications.www.OnBarcode.com
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.
Encode QR Code In Java
Using Barcode generator for Java Control to generate, create QR Code ISO/IEC18004 image in Java applications.www.OnBarcode.com
Barcode Printer In VS .NET
Using Barcode creation for Visual Studio .NET Control to generate, create Barcode image in Visual Studio .NET applications.www.OnBarcode.com
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.
Print GTIN - 13 In .NET
Using Barcode generator for ASP.NET Control to generate, create European Article Number 13 image in ASP.NET applications.www.OnBarcode.com
Barcode Maker In Objective-C
Using Barcode encoder for iPhone Control to generate, create Barcode image in iPhone applications.www.OnBarcode.com
10.3. Publishing with Interactivity: Pivot Charts and Pivot Tables
Drawing UPC - 13 In Visual Studio .NET
Using Barcode creator for .NET framework Control to generate, create EAN 13 image in .NET applications.www.OnBarcode.com
UCC-128 Creator In Objective-C
Using Barcode generator for iPad Control to generate, create GS1 128 image in iPad applications.www.OnBarcode.com
Creating QR In None
Using Barcode creator for Office Excel Control to generate, create Quick Response Code image in Excel applications.www.OnBarcode.com
Barcode Decoder In Visual C#.NET
Using Barcode decoder for .NET framework Control to read, scan read, scan image in .NET framework applications.www.OnBarcode.com
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.
Scan Code 128A In Visual Basic .NET
Using Barcode decoder for VS .NET Control to read, scan read, scan image in VS .NET applications.www.OnBarcode.com
Draw EAN-13 Supplement 5 In Java
Using Barcode maker for Android Control to generate, create EAN 13 image in Android applications.www.OnBarcode.com
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
reports will be static on the worksheet.
10.3 PUBLISHING WITH INTERACTIVITY: PIVOT CHARTS AND PIVOT TABLES
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.