go back to ordinary pivot table and plot an ordinary chart from it. If
the number of rows can vary, you will need a IF formula that ignores:

blanks
the data header
grand total


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=551779