Ignoring data points for regression lines

E

epolin

New Member
Joined
Apr 20, 2008
Messages
3
Is there a way when creating a regression line on a XY scatter graph to have the regression line ignore a couple of data points, but still have the points show on the chart?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
Create a 2nd series on the chart that excludes those points and run a regression on this new series.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Chart types on the same axis, different 0.0 spots
Replies
0
Views
88
PuckMark19
P
S
  • Question
Trendline values using Dynamic Range in Excel - comparing with LINEST function
Replies
1
Views
265
Domenic
D
T
  • Solved
Chart point must move to point of click in chart
Replies
2
Views
96
tigger_na
T
Z
  • Question
overlay data points on clustered column chart
Replies
0
Views
304
zachbaker
Z
C
  • Question
Plotting 3 points per data set in lollipop-type chart
Replies
2
Views
269
charllottesu
C

Forum statistics

Threads
1,215,471
Messages
6,125,002
Members
449,202
Latest member
Pertotal

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top