Plotting trendline for select data points, not entire data set.

Prometheus03

New Member
Joined
May 31, 2011
Messages
1
Hey all,

Im trying to plot some graphs of chemical reactions, and i need to get the slope of the line of the initial reaction, before it slows down. This is the first 3 or 4 points of the data set. However when i plot the trendline, it does the entire data set and not just the first few points.
Is there anyway to get excel to trendline the first few data points, or is there anyway i can manually select the points i want trendlined?
It seems like a really obvious thing that microsoft has overlooked...
I don't mind if i have to download add-ons or anything to make this possible.

Thanks in advance for any help!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,224,518
Messages
6,179,248
Members
452,900
Latest member
LisaGo

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