Thank you I believe I have seen your post. I know how to set up the
named range what I can't figure out is how to get the chart to only
plot the cells that have values and ignore the ones that are blank.

Thanks


--
cooter24
------------------------------------------------------------------------
cooter24's Profile: http://www.excelforum.com/member.php...o&userid=29619
View this thread: http://www.excelforum.com/showthread...hreadid=505416