XL2000: How to Create a Normal Chart from a PivotTable

ID: Q231421

The information in this article applies to:
  • Microsoft Excel 2000

SUMMARY

When you use a PivotTable as the source data for your chart, Microsoft Excel always creates a PivotChart. This article discusses how to create a normal chart (not PivotChart) from PivotTable data.


MORE INFORMATION

Use either of the following methods.

Method 1: Copy Part of the PivotTable Data to a Blank Chart

One method for creating a standard chart from a PivotTable is to copy part of the PivotTable to a blank chart. To do this, follow these steps:
  1. Select a blank cell outside the PivotTable.


  2. On the Insert menu, click Chart.

    The Chart Wizard starts.


  3. Use the Chart Wizard to define the type of chart that you want to create. When you click Finish, the Chart Wizard inserts a blank chart object on your worksheet.

    NOTE: The chart preview that is normally shown in step 3 of the Chart Wizard will be blank.


  4. Select the data in the PivotTable that you want to chart.

    NOTE: Do not select the entire PivotTable. You may want to exclude the field headings and the Grand Total.


  5. On the Edit menu, click Copy.


  6. Click to select the chart object that you created in step 3.


  7. On the Edit menu, click Paste.

    Excel pastes the PivotTable data into the chart.


NOTE: Because you pasted a specific range of cells into the chart, the chart will not display any new items that you add to your PivotTable.

Method 2: Copy the PivotTable Data to Another Part of Your Worksheet

You can create a normal chart from the data contained in your PivotTable if you first copy the PivotTable data to another part of your worksheet. To do this, follow these steps:
  1. Select your PivotTable.


  2. On the Edit menu, click Copy.


  3. Select a blank cell on your worksheet.


  4. On the Edit menu, click Paste Special.


  5. Click Values, and then click OK.


  6. Select the pasted cells, and then use the Chart Wizard to create your chart.


NOTE: Because you are not creating your chart directly from the PivotTable, the chart will not reflect changes to the PivotTable.

Additional query words: XL2000

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


Last Reviewed: June 25, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.