View Single Post
  #5   Report Post  
Vicky
 
Posts: n/a
Default

Jon, I would like to remove it from the calculation of the trendline. Thank
you. How do I do that?
Vicky


"Jon Peltier" wrote:

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.