XL2000: PivotChart Data Labels Lost When Published Interactively

A PivotChart which has data labels displayed may have some or all of the labels missing when viewed in a Web browser.

This problem may occur when the following conditions are true:

• You create a PivotChart with multiple series.
  
  -and-
  
  
• The PivotChart shows data labels.
  
  -and-
  
  
• The legend, when visible, shows numeric labels.
  
  -and-
  
  
• The legend labels are derived from cells that are formatted as Accounting in the PivotTable.
  
  -and-
  
  
• The PivotChart is published as a Web page with interactivity.

To work around the problem, follow these steps:

1. On the PivotTable sheet, select the cell below the Column Field label, right-click that cell, and click Field Settings.
2. Click Number.
3. In the Format Cells dialog box, click Currency under Category. Click one of the top two items under Negative numbers, and then click OK.
4. Click OK to dismiss the PivotTable Field dialog box.
5. Republish the PivotChart.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

When the number format of the series labels is Accounting, and you change that to the Number format, the data labels may still be missing when published. Under other conditions, the Number format does not display this problem. If you change the format to General, and then change the format to Number, the problem does not occur.

The problems described in this article also do not occur under the following conditions:

• If you publish standard charts with interactivity.
  
  -or-
  
  
• If you publish PivotCharts as Web pages without interactivity, or save them as HTML formatted files.

For more information about changing the number formatting in a PivotTable, click Microsoft Excel Help on the Help menu, type Change the number format for the data area in a PivotTable report in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about placing a chart on an interactive Web page, click Microsoft Excel Help on the Help menu, type Put a chart on a Web page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.