Charting

  • Thread starter Thread starter Dave Jones
  • Start date Start date
D

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Charting help for a novice? 3
Stacked Bar Chart 1
Scatter Chart 1
Make Chart refer to user defined worksheet 4
Chart is recognizing "" data as 0 1
Dynamic Chart with blanks 1
Excel 2000 Chart Problems 3
How to create a formula that results in a blank cell if required 7

Back
Top