The #N/A should be the result of the function NA() and not just typing
the literal "#N/A".

Also, a #N/A is *not* treated as 'leave a gap' for a line chart or a XY
Scatter chart but rather as a 'interpolate across the #N/A.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hello;

When some cells of the data series have #N/A values returned by formulas,
the corresponding chart fails.
But if the #N/A values are manually entered into those same cells, the chart
works fine !!
To my understanding, Excel Charts treat cells with #N/A values as empty
cells, so one may select the relevant chart option to "leave gaps", which is
perfect.

With this apparent different interpretation (by Excel Chart) of the same
#N/A values in the data series, how can I make the #N/A values returned by
formulas acceptable by the chart ??

Thank you for your help.