Microsoft KB Archive/231421

= HOW TO: Create a Normal Chart from a PivotTable in Excel 2000 =

Article ID: 231421

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q231421



IN THIS TASK
SUMMARY
 * Method 1: Copy Part of the PivotTable Data to a Blank Chart
 * Method 2: Copy the PivotTable Data to Another Part of Your Worksheet



SUMMARY
This step-by-step article describes how to create a normal chart (not a PivotChart) from PivotTable data. Ordinarily, if you use a PivotTable as the source data for your chart, Microsoft Excel always creates a PivotChart.

To create a normal chart (not a PivotChart) from PivotTable data, use either of the methods described in this article.

back to the top

Method 1: Copy Part of the PivotTable Data to a Blank Chart
One way to create 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.
 * 1) 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.
 * 1) 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.
 * 1) On the Edit menu, click Copy.
 * 2) Click to select the chart object that you created in step 3.
 * 3) 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.

back to the top

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.

back to the top

Additional query words: XL2000

Keywords: kbhowtomaster kbchart KB231421

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.