View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Holly Holly is offline
external usenet poster
 
Posts: 94
Default how to show the total in a pivot chart

I have a chart for pivot table, the data table showed on chart only display
the data area in pivot table, but not the totals for each column, even the
columns have the totals in pivot table.


I have two field buttons in data area, I tried "Calculated Items", but it
only totals the 2nd field in the columns, the first field just totas all the
2nd field all over again.

Holly