How to view the TOTAL values in the 3D graphic- from a Pivotal tabel

[marthab]

Hello

I have a pivotal table, and I have created a 3D graphic to show th
results.

However I would like to have the TOTAL (for each supplier) in th
graphic as well, and I do not know how to do it.

I am sending the file where is easy to understand ...


Anyone can help?
Thanks a lot in advance
Kind Regards
Mart

Attachment filename: question about the total.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=69739

 

[Debra Dalgleish]

I don't know of any way to include the grand total in a PivotChart. You
can 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