View Single Post
  #14   Report Post  
Posted to comp.os.linux.advocacy,comp.os.ms-windows.apps.misc,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc
Onion Knight Onion Knight is offline
external usenet poster
 
Posts: 18
Default Correct process for creating a linear trend line in Excel

On Jun 15, 9:16*pm, Onion Knight wrote:
There has been some debate in COLA as to the correct way to create a
linear trendline in Excel. Someone in the forum kindly made a video to
show what he thought was the correct methodhttp://tmp.gallopinginsanity.com/LinearTrendLineCreation.mov

A couple of other people in the group say that the video skips a
number of steps but when I look at the directions from Microsoft I do
not see any they could be referring to.

Does anyone see any missing steps for the creation of a linear trend
line? I admit this is a bit over my head so any input would be welcome.


Thank you to all who responded. The answer is now clear and Snit made
his trend lines correctly. They showed an increase in Linux usage in
2011 and a decrease in 2012. CC has now admitted his process was so
****ed up he could not even see the change in the trend and thought
the data was at flaw when it was his own process.