Charting help for a novice?
 

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

Charting help for a novice?
 

=if(A1,A1*14,NA()) should cure it on the chart.

If you don't want the NA# to show in your data sheet, you can hide it with
conditional formatting.
--
David Biddulph

"Dave Jones" wrote in message
...
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

Charting help for a novice?
 

Can you advise me on what expression to use in conditional formatting? I
have tried Cell value = #N/A and White font, but this doesn't work
Thanks
Dave

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=if(A1,A1*14,NA()) should cure it on the chart.

If you don't want the NA# to show in your data sheet, you can hide it with
conditional formatting.
--
David Biddulph

"Dave Jones" wrote in message
...
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

Charting help for a novice?
 

Formula is: =ISNA(B1)
--
David Biddulph

"Dave Jones" wrote in message
...
Can you advise me on what expression to use in conditional formatting? I
have tried Cell value = #N/A and White font, but this doesn't work

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=if(A1,A1*14,NA()) should cure it on the chart.

If you don't want the NA# to show in your data sheet, you can hide it
with
conditional formatting.

"Dave Jones" wrote in message
...
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