In the first step of the PivotTable wizard, use the 'Multiple consolidation
ranges' option. In the next step you will be asked about page fields.
Select the 'I will create the page fields' option. In the next step, add as
many ranges as you want -- well, in your case that will be two. Select the
first table (months and unit sales columns ) and click Add. Then, select the
2nd table (months and sales$ columns). and click add. Make sure you set the
'How many page fields do you want?' to zero.

The rest is like any other PT.
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"johnjmcdermott" wrote:

I have two sets of data ranging from 2000 to 2006 split into monthly totals
One set relates to Units produced per month; the other to units sold per month

I want to show both sets of data in a Pivot table together on one linear
pivot chart.

Anybody know how I can manage this ?

thanks