View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
MattBeckwith
 
Posts: n/a
Default How to ignore blank cells


Bernard Liengme Wrote:
1) Click chart to activate it
Use Tools | Options; open Chart tab; specify how empty cells are to be
treated


Actually, I had already set it to not plot empty cells, but it does
anyway. It seems I can't attach an Excel file to this message, but if
you give me your email address I'll send it to you. My email address
is . Thanks.


--
MattBeckwith


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