Display exact value in Excel chart
mimi.dbg
-
tontong Posted messages 2575 Registration date Status Membre Last intervention -
tontong Posted messages 2575 Registration date Status Membre Last intervention -
Hello,
I created a scatter plot with a trend line.
I wanted to know if it's possible to make the graph "dynamic" so that when you hover the mouse over it, it displays the precise values, either from the location of the cursor or at least the intersection points of the trend line?
Thank you in advance for your responses, and if you need more details, feel free to ask!
Configuration: Windows 7 / Firefox 5.0
I created a scatter plot with a trend line.
I wanted to know if it's possible to make the graph "dynamic" so that when you hover the mouse over it, it displays the precise values, either from the location of the cursor or at least the intersection points of the trend line?
Thank you in advance for your responses, and if you need more details, feel free to ask!
Configuration: Windows 7 / Firefox 5.0
3 réponses
Hello,
Just a little nudge in case you decide to dive into the world of macros.
Hovering the mouse over a point in a series shows the coordinates in a tooltip.
You can calculate the trendline equation using the "LINEST" or "TREND" function.
The macro used to calculate the intersections in the "Complex Intersections" file may serve as a base for you.
https://andypope.info/charts.htm
Good luck.
Just a little nudge in case you decide to dive into the world of macros.
Hovering the mouse over a point in a series shows the coordinates in a tooltip.
You can calculate the trendline equation using the "LINEST" or "TREND" function.
The macro used to calculate the intersections in the "Complex Intersections" file may serve as a base for you.
https://andypope.info/charts.htm
Good luck.
