XL5: Pivot Table Data Not Added To Chart After Dragging

• Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel, when you create an embedded chart from data in a pivot table, and the chart overlaps the pivot table data, if you drag data from the pivot table to the chart, the data may move to a different location in the pivot table, instead of being added to the chart.

CAUSE

This behavior occurs if the embedded chart is positioned on top of any part of the data area on the pivot table, and you drag pivot table data to a location in the pivot table that is under the chart, before dragging the data to the chart.

If the border that is displayed to indicate the size and location of the data that you are dragging is behind the embedded chart just before you drag the data to the chart, the data is not added to the chart.

WORKAROUND

To add the pivot table data to the chart, instead of just moving the pivot table data, drag the data directly to the chart, instead of dragging it to another location in the pivot table first.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in a later version of Microsoft Excel.

REFERENCES

For more information about Adding Data Series Or Data Points To An Embedded Chart, choose the Search button in Help and type:

    dragging, cell ranges to charts