Hi Bill,

Add an empty chart (do not select the pivot table)
Then right-click the chart and...

XL 2003 -
Select 'Source Data...', then Series tab.
Add a series, select cells you want.

XL 2007 -
Select 'Select Data...'
Add a series, select cells you want.

Ed Ferrero
www.edferrero.com

I want to create my own chart based on a pivot table.
All I seem to be able to get is a Pivot Chart.
Is there a way to achieve this please?
Bill