I sometimes need a chart based on the output of a pivot table which of
course grows and shrinks over time as the raw data changes. I set up a
few columns to the right of the pivot table and test if the relevant
cell in each row is empty (then ignore) or contains grand total (then
ignore) otherwise return the value in the cell. Plot chart as normal.
You do get the blank cell from a fomula plotting as zero on the chart
problem though.


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