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

Dealing with a Pivot Table (when I don't want to) 0
Slicers and Calculated Items in Pivot Table 2
Pivot Table Column Totals - XL2003 5
Consolidation Table from Different Excel Tabs with Different Format 1
Pivot table 0
Excel 2007 - Pivot Tables Include Filtered / Hidden Values inSubtotal / Total 0
Pivot Table Counting Text Data 0
Pivot table grand total location 1

Top