Charting

[Dave Jones]

I have a value in Column A and a calculated value in column B
=if(A1,A1*14,"")

I want to plot column B on a chart, however where there is no data in A then
the chart plots B as a zero, but I don't want it to plot anything if there
is no data. Can anyone help this relative novice?

Thanks in anticipation
Dave

 

[Andy Pope]

Hi,

Charts will treat "" as zero. As charts treat all text within value
ranges as zero. So instead use NA() in your formula.

=if(A1,A1*14,NA())

Cheers
Andy