how to show the total in a pivot chart

H

Holly

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Column Totals - XL2003 5
Pivot Table Charts - Help Required 1
Referencing a pivot tables Grand Totals Column 1
Pivot Table Chart? 4
Pivot Table - 3
Grand Total for Rows not Working in a Pivot Table 1
Showing Pivot Table total on Associated Pivot Chart 2
Excel 2003 Pivot Table - Grand Total 4

Top