Microsoft KB Archive/210737

= XL2000: Cannot Change PivotChart Source Range =

Article ID: 210737

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

