How do you ignore a data point?
 

Say my data set is
10, 15, 90, 12
I want to plot all the values but not connect/interpolate 90 as it is an
outlier.

How do I do this, I'm sure it's easy.

Many Thanks Julie

How do you ignore a data point?
 

Make two series, one with the three good points, one with the outlier.
Connect the points in the first series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ju1eshart" wrote in message
...
Say my data set is
10, 15, 90, 12
I want to plot all the values but not connect/interpolate 90 as it is an
outlier.

How do I do this, I'm sure it's easy.

Many Thanks Julie