I have a chart which pulls data from various worksheets. The data
changes monthly, so each new month there are lots of blank cells which
don't yet have values. But the chart continues on for the blank days,
giving each a value of zero (even though the cells contains spaces, not
zero). Is there an option to not chart data points when they're blank
(or zero)? Thanks!


--
MattBeckwith


------------------------------------------------------------------------
MattBeckwith's Profile: http://www.excelforum.com/member.php...o&userid=30571
View this thread: http://www.excelforum.com/showthread...hreadid=511363