XL: Cannot Move or Resize Chart Objects in a PivotChart (199201)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Excel 2000
This article was previously published under Q199201

SYMPTOMS

When you use the mouse to try to move or resize parts of a chart, you cannot move the following elements of the chart:
  • Axes' titles
  • Chart title
  • Plot Area
  • Legend
  • Value Axis Display Unit Label

CAUSE

When you create a chart based upon a PivotTable report, you cannot move or resize some PivotChart objects. Moving or resizing the chart elements listed in the "Symptoms" section would change the layout of the PivotChart report; therefore, you cannot change them.

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

REFERENCES

For more information about creating a PivotChart Report, click Microsoft Excel Help on the Help menu, type Create a PivotChart report in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:5/13/2003
Keywords:kbchart kbprb KB199201
©2002 Microsoft Corporation. All rights reserved.