D DaG Jan 24, 2004 #1 i need to know how to select certain data points on a scatter graph, s i can create a linear trend line just for those points
i need to know how to select certain data points on a scatter graph, s i can create a linear trend line just for those points
T Tushar Mehta Jan 24, 2004 #3 Add those points as a new series. Then, create a trendline for this new series. If these points have some pattern to them, the ideas behind the Excel/Tutorials/Select Markers page of my web site might help. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions
Add those points as a new series. Then, create a trendline for this new series. If these points have some pattern to them, the ideas behind the Excel/Tutorials/Select Markers page of my web site might help. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions