How to Create a Pivot Chart in Excel 2007

One feature of Microsoft Excel 2007 is the ability to create pivot charts, or pivot tables. Pivot charts are used to organize and view data. If you have some data that you want to use to create a pivot chart, it takes only a few clicks of the mouse to get started. After you use your data to create a pivot chart, you can move the data fields around on the pivot chart.

Instructions

1. Open the Excel workbook that has the data you want to use to create a pivot chart.

2. Highlight the data you want to add to the pivot chart.

3. Click the "Insert" tab and look to the "Tables" section of the ribbon.

4. Click "Pivot Table" and select "Pivot Chart" from the drop-down menu. The "Pivot Chart" dialog box will open.

5. Select a range of cells to add to the chart if you want to include more data than you have already selected. You can also select data from an external source. If you want to do this, check the box next to "Use an external data source" and then click "Choose connection." Select a data source from the box that opens and click "Open."

6. Choose where you want the pivot chart to be placed. You can insert the chart in the worksheet you have open or you can insert it in a new worksheet.

7. Click "OK." The pivot chart will be inserted in your Excel spreadsheet.

References

• Microsoft: Create or delete a Pivot Chart