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!

Only chart numerical values, not error values
 

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!

Only chart numerical values, not error values
 

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!