Charting

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
 
A

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
 

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
Make Chart refer to user defined worksheet 4
Chart is recognizing "" data as 0 1
Excel 2003 - VBA - Charting 2
Show other cell if blank 5
Charting based on a specific month in a column 1
How to retrieve source data from data plots only? 1
How to create a formula that results in a blank cell if required 7

Top