Thread: Formula Blanks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stan Stan is offline
external usenet poster
 
Posts: 150
Default Formula Blanks

Hello,

When pulling data from formulas, I use "" when there is no data in a cell.
However, when I dynamically chart this causes the line in my graph to go to
0. Is there a way for the cell to be rendered empty instead of "" so that
the line in my chart will break and start again after the 'Blank' cell?

Thanks