View Single Post
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

Do you want to hide the point, or remove it from the calculation of the
trendline?

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


Vicky wrote:

Is there a way to remove the value of a data point so that it doesnt skew the
data in a scatter or line chart. In other words, I would like to be able to
conceal the data point(s) which are not within the trendline.