Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I fit a line on an excel plot to a portion of the data?
I want a best fit line to go pass through the obviously linear portion of the
data and ignore all other points, how do i do this? |
#2
|
|||
|
|||
Answer: How do I fit a line on an excel plot to a portion of the data?
To fit a line on an Excel plot to a portion of the data, you can use the trendline feature. Here are the steps:
By following these steps, you should be able to fit a best fit line to a portion of the data in Excel.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I fit a line on an excel plot to a portion of the data?
Hi,
Trend lines are based on all the data points in a series. To get a trend line on a subset of data you will need to add a new series based on only that subset. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mechengstudent" wrote in message ... I want a best fit line to go pass through the obviously linear portion of the data and ignore all other points, how do i do this? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I fit a line on an excel plot to a portion of the data?
Hi,
If you want the chart to do this, then one way is to plot the "obvious linear protion" as one series and the rest as another series and then select the above portion and choose Chart, Add Trendline. You could also manually calculate the trendline in the spreadsheet for the points that make up the "obvious linear portion" using some combination of the LINEST, TREND, SLOPE or INTERCEPT spreadsheet functions. Then you would calculate and plot the trendline as a separate series. I suspect you can find at least one example at Jon's website. Google Excel Charts and look for Jon Peltier's sites. -- Thanks, Shane Devenshire "mechengstudent" wrote: I want a best fit line to go pass through the obviously linear portion of the data and ignore all other points, how do i do this? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I fit a line on an excel plot to a portion of the data?
Here's a link to an interactive Excel regression tool that let's you select
which continuous set of data points you want to do regression on. http://processtrends.com/toc_trend_a...e_Regr ession Let me know if you need any further help Kelly http://processtrends.com "mechengstudent" wrote in message ... I want a best fit line to go pass through the obviously linear portion of the data and ignore all other points, how do i do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
How to add a line plot onto a stacked plot in Excel | Charts and Charting in Excel | |||
combined scatter plot and line data | Excel Discussion (Misc queries) | |||
How do I plot both line and column data on same graph? | Charts and Charting in Excel |