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

how to show the total in a pivot chart
 

I have same question. Have you had any luck with adding totals to a chart?

"Holly" wrote:

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