XL: Cannot Move or Resize Chart Objects in a PivotChart

MORE INFORMATION

In Microsoft Excel, you can create a chart based on a PivotTable. When you create a PivotChart report from a PivotTable report, row fields in the table become category fields in the chart, and column fields in the table become series fields in the chart.

A PivotChart can use any of the available chart types in Excel except for xy (scatter), bubble, or stock chart types. When you change the layout of the PivotChart report by dragging a field, the layout of the associated PivotTable report also changes. However, unlike a chart that is not based upon a PivotTable report, the following elements of the chart are unmovable, and you cannot resize them in a PivotChart report:

• Axes' titles
• Chart title
• Plot Area
• Legend
• Value Axis Display Unit Label