How to Create a Pivot Chart in Excel 2007

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.