extract the data from the pivot table by , say, if output is in column
G,
=if ( G3="","",if g3="grand total","",g3))
then copy this down a few hundred rows
this only pulls data and ignores blanks and the last row which is grand
total.
now just highlight the data and click on chart wizard and follow it
through.
--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread:
http://www.excelforum.com/showthread...hreadid=551779