Hi, works well! Thanks for the tip. Roger

"R.VENKATARAMAN" wrote in message
...
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