Thread: Stopping chart line where 1 of 2 columns of data in calculation is blank

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

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

Roger B. <rb10@canada.com> wrote in message
news:uVTrncciFHA.320@TK2MSFTNGP09.phx.gbl...
> 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
>
>

Hi, works well! Thanks for the tip. Roger

"R.VENKATARAMAN" <vram26@vsnl$$$.net> wrote in message
news:uZ76xQeiFHA.3960@TK2MSFTNGP12.phx.gbl...
> is there not a provision in
> tools-opiton-chart
> plot empty cells - not plotted
>
> Roger B. <rb10@canada.com> wrote in message
> news:uVTrncciFHA.320@TK2MSFTNGP09.phx.gbl...
>> 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
>>
>>
>
>