XL2000: PivotChart Data Labels Lost When Published Interactively

• Microsoft Excel 2000
• Microsoft Office Chart Component 9.0, run time

SYMPTOMS

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

CAUSE

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.

WORKAROUND

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

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.

REFERENCES

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.

Additional query words: XL2000

Keywords : kbchart xlpivot
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug