1) Click chart to activate it
Use Tools | Options; open Chart tab; specify how empty cells are to be
treated
OR
2) Learn about dynamic charts at
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
OR
3) use =NA() in blank cells, see
http://www.stfx.ca/people/bliengme/E...issingData.htm
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MattBeckwith"
wrote in message
...

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