XL2000: Unable to Move or Resize Chart Objects in a PivotChart

ID: Q199201

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you use the mouse to try to move or resize parts of a chart, the following elements of the chart are unmovable:

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

CAUSE

When you create a chart based upon a PivotTable report, some PivotChart objects cannot be moved or resized. 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.

Additional query words:

Keywords : kbdta kbchart xlpivot
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb