You can't include the totals or subtotals in a pivot chart. You could
create a normal chart, based on the pivot table, and include the totals
in that.

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm


Kompu Kid wrote:
Hello All:

I am presenting rolling 13 weeks of data on various manufacturing
problemin our operations with a pivot chart. On the chart I would like
to show the subtotals for each problem as well but I cannot figure
out a way of doing this.

Any suggestions?

Thanks!

Deguza

----------------------------------- Sample pivot chart
---------------------------------------



Sum of Qty
Product Problem Week Total
Blue_gadget Assembly error 2007 12
2007 14
2007 13
2007 15
2007 16 18
2007 17 4
2007 19
2007 20 6
2007 18 10
2007 21
2007 22
2007 23
2007 24
Assembly error Total 38

[...]

Damaged part 2007 12
2007 14
2007 13
2007 15
2007 16
2007 17
2007 19
2007 20 13
2007 18
2007 21
2007 22
2007 23
2007 24
Damaged part Total 13



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html