XL2000: Data Labels on Published PivotCharts May Lose Number Formatting

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

SYMPTOMS

Data labels in a PivotChart which have number formats other than General may lose that number formatting when published as a Web page.

CAUSE

This problem occurs when you do the following:

• You format a PivotTable data range with a number format other than General.
  
  -and-
  
  
• You display data labels as values on a PivotChart linked to that PivotTable report.
  
  -and-
  
  
• You click Save as Web Page on the File menu, click Publish in the Save As dialog box, click to select Add interactivity with Chart functionality, click Publish and view the resulting published Web page chart in a browser.

WORKAROUND

To work around this problem, manually format the data labels before publishing the chart by following these steps:

1. Right-click a data label in a series to select all data labels in that series, then click Format Data Labels.



2. On the Number tab, click the number format you want.



3. Make sure the Linked to source check box is cleared and click OK.



4. Republish the chart.


NOTE: If the format you want is already selected due to cell formatting in the PivotChart, you still must click the format name before you click OK.

STATUS

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

MORE INFORMATION

This problem does not occur with PivotCharts that you save as HTML formatted files or publish as Web pages without interactivity.

If a chart other than a PivotChart is published as a Web page with interactivity, data labels with number formatting received from cell links will retain that formatting.

REFERENCES

For more information about Excel and Web pages, click Microsoft Excel Help on the Help menu, type "web pages" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.


For more information about limitations of interactive data on a Web page, click Microsoft Excel Help on the Help menu, type "Limitations of putting interactive data 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