Excel Chart displaying blank data as zero

[mfd]

I have an excel chart which gets data from a seperate sheet. When the external sheet has data inputted, the data will be reflected in my excel worksheet and consequently the graph. I have used the statement :

=IF('V:\Planning\Indicator\[Safety Exam Faults.xls]Safety Exam Faults'!D12<>&quot;&quot;,'V:\Planning\Indicator\[Safety Exam Faults.xls]Safety Exam Faults'!D12,&quot;&quot

to avoid showing blank (i.e not yet available) data but the excel chart assumes the cells which are &quot;&quot; have the value as 0. How can I get the chart not to show the blank cell values?

Cheers

Matt

 

[AWithers]

I have used the #N/A value in the past, its value in null rather than 0

e.g.

=IF('V:\Planning\Indicator\[Safety Exam Faults.xls]Safety Exam Faults'!D12<>&quot;&quot;,'V:\Planning\Indicator\[Safety Exam Faults.xls]Safety Exam Faults'!D12,#N/A)

Hope this helps

Andy

 

[mfd]

Thankyou!!!!

Works a treat!!

The sweet smell of a (minor) monday morning victory.....

 

[Hasit]

mfd, I have written an FAQ about your question, which may give you further information:

faq68-1277