If you open a workbook created in an earlier version of Microsoft Excel that contains a chart made from a PivotTable, you cannot change that chart to a PivotChart.
↑ Back to the top
Charts made in earlier versions of Excel from PivotTable data are maintained as regular charts, rather than being converted to PivotCharts.
↑ Back to the top
The fastest and most reliable way to work around this problem is to create a new PivotChart from the PivotTable report.
To create a new PivotChart, select a cell in the PivotTable and click the Chart tool on the Standard or PivotTable toolbar. Excel will create a PivotChart on a new chart sheet.
↑ Back to the top
A chart that is not created from PivotTable data will be converted to a PivotChart if you change the data source to a PivotTable. After linking a PivotChart to PivotTable data, you can no longer change the data source.
↑ Back to the top
For more information about PivotCharts, click Microsoft Excel Help on the
Help menu, type PivotCharts in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
↑ Back to the top