Thread: Chart displaying "blank" cells?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default Chart displaying "blank" cells?
Hi,

Use NA() instead of "" which will return a #N'A instead of a empty string.
Your chart will not plot the #N/A

Dave

url:http://www.ureader.com/msg/10296332.aspx
Reply With QuoteReply With Quote