Trendline Polynomial won't go above 3rd Order

Post Reply
User avatar
JezShed
Posts: 79
Joined: Sun Jun 14, 2009 3:55 pm

Trendline Polynomial won't go above 3rd Order

Post by JezShed »

I accidentally encountered a problem when adding a polynomial trendline to a simple scatter chart of some test data.
I can adjust the polynomial "order" from linear (1st order) all the way up to 6th order. I can see the preview of the trendline is changing as I increment the order number. But accepting my desired selection of 6th order, the trendline is indeed 6th order but the displayed equation is only 3rd order.
The same problem occurs in PM2024 and NX Beta. I haven't tried it in earlier versions, but I am fairly sure it used to work correctly for higher order polynomial trendlines.
To make sure I'm doing it correctly, I opened the same file in Excel and the polynomial is correctly displayed.
In PlanMaker NX Beta (or indeed PM 2024), if you right-click on the trendline and select trendline properties, you can see that 6th order has been set correctly.

Can you reproduce it?
Thank you!
Jez
Attachments
Polynomial shown to 3rd order only :(
Polynomial shown to 3rd order only :(
Polynomial correctly shown to 6th order
Polynomial correctly shown to 6th order
test-200mA.xlsx
Trendline polynomial
(12.65 KiB) Downloaded 16 times
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3924
Joined: Wed Mar 11, 2020 5:31 pm

Re: Trendline Polynomial won't go above 3rd Order

Post by SuperTech »

Thank you for the detailed report and the test file. I've been able to reproduce the issue and have forwarded it to the team for further investigation.
User avatar
JezShed
Posts: 79
Joined: Sun Jun 14, 2009 3:55 pm

Re: Trendline Polynomial won't go above 3rd Order

Post by JezShed »

That was a very fast reply, thank you!
I'm very (VERY) impressed by Softmaker and it's my absolute preferred set of Office tools and has been since I discovered you in 2008. I'm glad we have this community and connection with the developers that can look into issues. You wouldn't get that from "you know who".
Post Reply

Return to “BETA: PlanMaker NX and 2026 for Windows”