Excel Pivotchart/Table 'expert' needed please

[SexyGreyFox]

This is driving me nuts.

Here is an example of my problem - http://www.disturbinthepeace.co.uk/pics3/pivot.xls

I've highlighted all cells and then clicked on Pivotchart which takes me to a new sheet which I've called Pivot.
In the T, P and S columns are some big numbers bit the Pivot Chart only goes to 1 !!!

If I go lower down the spreadsheet and manually type all the numbers in and do the same it would work.
Common sense tells me that something must be happening in the cells of the original spreadsheet which doesn't translate properly when I try to Pivot Chart but I can't see what's going on.

Help

Thanks

 

[Skutter]

You have set the pivot to 'Count', rather than 'sum' in the wizard window?

 

[SexyGreyFox]

I owe you a squillion OCUK pounds - thanks