View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] fhobert@cesa1.k12.wi.us is offline
external usenet poster
 
Posts: 1
Default grand totals in pivot table rows

I'm trying to remove the grand totals.
I have data label in "rows" and the same in "values" so i can count each unique text and count the number of times they appear, and then show that in a pie chart. any ideas on how to remove the grand total? it is showing as a separate pie slice and making the whole pie off.

thank you!!!!