Removing a field in a pivotchart, but not in the pivot table

I have a pivot table created and want to create several charts to show different perspectives on the table. I have three fields pulled in as the rows. In one of my charts, I want to get rid of one of the fields that is currently a row because I do not want to show the breakdown of that field. But, when I remove it, the field is then removed from the pivot table. How do I remove the field from the chart only, while keeping the field in the pivot table?

Hi,

You cannot have fields in a pivot table but not in the linked chart. You must either use an additional pivot table or use a regular chart rather than a pivot chart.