Cheers Robert,
I've not got too much experience with charts!
How do I plot an ordinary chart from a pivot? ... whenever I try to
construct a chart from the data in the pivot it reverts to a pivot
chart !

Any help greatly appreciated
J

robert111 wrote:

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