How to remove a data point in a chart?

In that case, you need to remove the point from the data being plotted.
The best thing to do is make a copy of the data, construct the chart
with the copied data, and delete from the copy any outliers.

The chart calculates a trendline using every plotted point, whether you
hide it or not.

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


Vicky wrote:
> 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.
>>

Thank you very much

"Jon Peltier" wrote:

> In that case, you need to remove the point from the data being plotted.
> The best thing to do is make a copy of the data, construct the chart
> with the copied data, and delete from the copy any outliers.
>
> The chart calculates a trendline using every plotted point, whether you
> hide it or not.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> Vicky wrote:
> > 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.
> >>
>