Pivot Table & Chart

[shonaart]

Hi
I have a pivot table on and created a chart from the Pivot table.
I have 3 fields in my pivot table I want to see , but for my Chart I only want to see the one field. How do I remove the other two without the fields in the Table disappearing aswell.

Basically want to see 3 fields in my Table and 1 field in my Chart.

Thanks

 

[RoryA]

You can't. A pivot chart and table are linked directly. You either need 2 pivot tables, or you'd need to use a normal chart rather than a pivot chart.

 

[shonaart]

Thank you for that, I have to create seperate table.
Thanks