How do I set a trendline for only say the first 25% of the data s.

Q

qwerty

Hi, I have plotted a logarithmic distribution but only want the trendline to
take into account certain points and not the whole data series. However I
don't know how to select only the points I want to use.
Any help anyone could give me with this would be great.
 
J

Jerry W. Lewis

Use a second series on the chart that only contains the data of interest.

Jerry
 
J

Jim Cone

Add a second series to the chart using your "certain" points.
Add the trend line to the new series.
Format the new series so it can't be seen.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"qwerty" <[email protected]>
wrote in message
Hi, I have plotted a logarithmic distribution but only want the trendline to
take into account certain points and not the whole data series. However I
don't know how to select only the points I want to use.
Any help anyone could give me with this would be great.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove "linear" from trendline legend entry 2
Trendline in Stacked Column Chart 2
How do I stop trendline from touching the y-axis? 7
How do I add a trend line for only half of my graph? 1
How do I show slope of a trendline on a plot ???? 0
How do I adjust a curve ? 12
Trendline equation and data do not match up 3
Regression through select points on a scatter plot. 3

Top