is there not a provision in
tools-opiton-chart
plot empty cells - not plotted

Roger B. wrote in message
...
I have a chart where there are two columns of data used to create a number
in a third column. I have tried to use both #N/A, NA() and "" to stop the
resulting chart line when one of the 2 columns is blank but have had no
success.

Any suggestions would be greatly appreciated,

Roger