Help with PIVOT CHART please

[shaunkaz]

Hi All, can someone please help me with a pivot chart. I'm after a pivot chart to display the performance parts but not to sum up or count all the parts just display what you see below.. the chart is to have a filter for the shift so I can display by shift if needed.. So then I can see the performance of parts per hour on a line graph

Thanks

Shift	Ref	Performance parts per hour
1	Moulded Part	700
2	Moulded Part	700
3	Moulded Part	600
1	Moulded Part	700
2	Moulded Part	650
3	Moulded Part	600
1	Moulded Part	700
2	Moulded Part	675
3	Moulded Part	600