I would like to have data from two different worksheets on the same Pivot
table is this possible.
For example I have a spreadsheet with information relating to the year
2004/05 and a spreadsheet with the same type of information relating to
2005/06 to allow me to compare the both I would like to put them into a
single pivot table and then into a single chart.
--
pk

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

http://www.contextures.com/xlPivot08.html

PK wrote:
I would like to have data from two different worksheets on the same Pivot
table is this possible.
For example I have a spreadsheet with information relating to the year
2004/05 and a spreadsheet with the same type of information relating to
2005/06 to allow me to compare the both I would like to put them into a
single pivot table and then into a single chart.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html