Try using #N/A instead of "" eg
Regards,
Alan.
"stan" wrote in message
...
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