Printing Pivot Table Pie Charts
 

I have 1400 names in a list each, person has their own data. I created a
pivot pie chart to display that data. Can anyone tell me how to print the
pivot table so I get a separate sheet for each name selected...without me
having to click on the dropdown list each time?
Also does anyone know how to hide a field, but have the data still be
displayed in the pie chart?

thanks