how do i create a best fit line graph for results in a table?
thanks in advance
david
how do i create a best fit line graph for results in a table?
thanks in advance
david
See Help for info on the TREND and FORECAST functions if the fit is linear,
or GROWTH if exponential.
If more complex fit, please tell us more
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"David White" <[email protected]> wrote in message
news:[email protected]...
> how do i create a best fit line graph for results in a table?
>
> thanks in advance
> david
David -
Here are three alternatives:
(1) Use the ChartWizard to create an XY (Scatter) chart, and use Add
Trendline.
(2) Use the Regression tool of the Analysis ToolPak add-in, which will
create a chart with a fitted line.
(3) Use worksheet functions (TREND, GROWTH, etc.) to get fitted values, and
then use the ChartWizard to create the chart.
- Mike
www.mikemiddleton.com
"David White" <[email protected]> wrote in message
news:[email protected]...
> how do i create a best fit line graph for results in a table?
> thanks in advance
> david
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks