PDA

View Full Version : OpenOffice.org Spreadsheet: How do you add a trendline?



MarkE
9th July 2006, 04:52 PM
In OpenOffice.org Spreadsheet (I assume the equivalent of Microsoft Excel for Windows), when I make a graph, I can't find how to insert an automatic trendline using regression. In the help file, it actually has the string "trend lines in charts", but that just links to the help screen called "Inserting Charts" which doesn't mention trendlines at all!!! :mad: :mad: :mad: :mad: :mad: :mad: :mad: I found that many help topics have the same problem -- they for some strange reason link to "Inserting Charts" that has absolutely no mention of that topic whatsoever.

Help in how to add a trendline is appreciated.

addarich
9th July 2006, 05:09 PM
right click on the chart
select edit
select the data points
right click, select object properties
select the statistics tab
at the bottom you'll find the regerssions curves
hope it helps