Thread: How do you ignore a data point?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default 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





Reply With QuoteReply With Quote