XL2000: Cannot Change PivotChart Source Range (210737)

The information in this article applies to:

Microsoft Excel 2000

This article was previously published under Q210737

SYMPTOMS

If you click a PivotChart report, and then click the Chart menu or right-click the chart to change the source range, the Source Data menu item is dimmed and you cannot change the range.

CAUSE

You cannot change the source range of a PivotChart. You can only associate a PivotChart with one PivotTable report, and after making this association, you cannot change it to a different source.

WORKAROUND

If you need the PivotChart to refer to a different PivotTable, create a new PivotChart from that PivotTable.

MORE INFORMATION

You cannot edit a series formula in a PivotChart. If you select a series in the chart and click the formula bar showing the series formula, you receive the following message:

You cannot edit a PivotChart series with the formula bar. You can change the view of data in a PivotChart report by reorganizing its fields or items, or by changing its associated PivotTable report.

REFERENCES

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

Modification Type:	Major	Last Reviewed:	10/7/2003
Keywords:	kbprb KB210737