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 <pe...@apache.org <mailto:pe...@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

Reply via email to