Re: Calc: How to graph polynomial trend line like Excel?

[Regina Henschel]

Hi Mike,

helices schrieb am 13-Apr-20 um 18:51:

How can we create more complex trend lines in Calc, like the Polynomial
line in Excel?


Polynomial regression type is not implemented. You need to calculate it 
outside the chart and then add it as data series.


You might want to use an extension. Find more details in
https://bz.apache.org/ooo/show_bug.cgi?id=20819

Kind regards
Regina

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Calc: How to graph polynomial trend line like Excel?

[Peter Kovacs]

Mike,


I checked to day Excel 2016 and the main difference is that OpenOffice 
does not have a + Symbol.


Okay, maybe when you have the Graph selected, then you need to double 
click, to be able to manipulate the Graph itself.


And then you can select the line you want to add the trend line too.

And only then you see the trend line in the Menu.


By now I found the wiki article too:

https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Editing_charts


Hope that clarifies.

Best

Peter


Am 13.04.20 um 22:58 schrieb Mike Schleif:

Peter,

This does not work for me. I have not gotten anywhere with Insert 
Trend Line where there is any option to insert an equation.


Of course, devising my own equation is not the same as Excel doing it 
for me ...


What am I missing?

On Mon, Apr 13, 2020 at 3:33 PM Peter Kovacs > wrote:


Which Version do you use?

In 4.1.7 you can

1) select the Dots you want to add a trendline to.

2) right click

3) in the Menue select the trend line

4) select the Formula you want to add

5) if you click again, you can add the trendline formula to the
trendline.


I hope this helps.


Am 13.04.20 um 18:51 schrieb helices:
> How can we create more complex trend lines in Calc, like the
Polynomial
> line in Excel?
>
> ~ Mike
>



--
If I can ever be of service to you; contact me at once.

I wish for you a truly extraordinary day ...

Best Regards,

Mike Schleif
612-235-6060 http://mdsresource.net http://tofree.me/GooglePlus 
http://www.linkedin.com/in/schleif http://facebook.com/MDSResource 
http://twitter.com/mikeschleif

Re: Calc: How to graph polynomial trend line like Excel?

[Peter Kovacs]

Which Version do you use?

In 4.1.7 you can

1) select the Dots you want to add a trendline to.

2) right click

3) in the Menue select the trend line

4) select the Formula you want to add

5) if you click again, you can add the trendline formula to the trendline.


I hope this helps.


Am 13.04.20 um 18:51 schrieb helices:

How can we create more complex trend lines in Calc, like the Polynomial
line in Excel?

~ Mike



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Calc: How to graph polynomial trend line like Excel?

[helices]

How can we create more complex trend lines in Calc, like the Polynomial
line in Excel?

~ Mike