Only chart numerical values, not error values

In my data series I am using NA() in a formula so that #N/A shows up in the
cell. From the website listed below I thought that this would not chart the
error values but my charts are still conecting all my marks. Can Excel only
show my MIN/MAX marks?
=IF($B2=MAX($B2:$B$1562),$B2,NA())
http://peltiertech.com/Excel/Charts/FormatMinMax.html
Thanks!

Hi,

If you have #N/A in the cell then the point will not be plotted.
But if there is a valid data point(s) after it then the line will be
plotted to join those points interpolating the gap in between. It will
not leave put a break in the line.

This shows you what happens.
http://www.andypope.info/charts/brokenlines.htm

Or maybe you simply need to format the series so No border is plotted.

Cheers
Andy

andy wrote:
> In my data series I am using NA() in a formula so that #N/A shows up in the
> cell. From the website listed below I thought that this would not chart the
> error values but my charts are still conecting all my marks. Can Excel only
> show my MIN/MAX marks?
> =IF($B2=MAX($B2:$B$1562),$B2,NA())
> http://peltiertech.com/Excel/Charts/FormatMinMax.html
> Thanks!

My mistake, easy fix. Right-click the data series click 'Format Data Series'
'Patterns' and select 'None' for the line.
Thanks Andy.
"Andy Pope" wrote:

> Hi,
>
> If you have #N/A in the cell then the point will not be plotted.
> But if there is a valid data point(s) after it then the line will be
> plotted to join those points interpolating the gap in between. It will
> not leave put a break in the line.
>
> This shows you what happens.
> http://www.andypope.info/charts/brokenlines.htm
>
> Or maybe you simply need to format the series so No border is plotted.
>
> Cheers
> Andy
>
> andy wrote:
> > In my data series I am using NA() in a formula so that #N/A shows up in the
> > cell. From the website listed below I thought that this would not chart the
> > error values but my charts are still conecting all my marks. Can Excel only
> > show my MIN/MAX marks?
> > =IF($B2=MAX($B2:$B$1562),$B2,NA())
> > http://peltiertech.com/Excel/Charts/FormatMinMax.html
> > Thanks!
>