ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   display when touching a selected polynomial trendline (https://www.excelbanter.com/excel-programming/367773-display-when-touching-selected-polynomial-trendline.html)

[email protected]

display when touching a selected polynomial trendline
 
Hello,

I have a Chart Type xlXYScatterLinesNoMarkers with a 5th degree
polynomial trendline.
I know how to extract the parameters of that trendline with the
"Linest" formula, so I can build a formula that calculates the
derivatives of my trendline at any given point.

So calculating the value is not the problem.
What I want is that this derivative value pops up when I touch the
trendline at the given point.
I found out that touching a selected trendline with the cursor pops up
a little display saying something like "Series 1 Trendline1".
Something like that would be great.

Would this be too long a shot or is it feasible ? If not, I'd be
grateful for any other suggestion to display the derivative value by
just "tickling" the chart.

Thank you very very much.

Herman



All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com