You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by helices <mi...@mdsresource.net> on 2020/04/13 16:51:21 UTC
Calc: How to graph polynomial trend line like Excel?
How can we create more complex trend lines in Calc, like the Polynomial
line in Excel?
~ Mike
Re: Calc: How to graph polynomial trend line like Excel?
Posted by Regina Henschel <rb...@t-online.de>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Calc: How to graph polynomial trend line like Excel?
Posted by Peter Kovacs <pe...@apache.org>.
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 <petko@apache.org
> <ma...@apache.org>> 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?
Posted by Peter Kovacs <pe...@apache.org>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org