Is there any way to find X and Y value at any point in graph by moving cursor??.
(In 2003 i need to drag x and y value into graph for finding any point value)
April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
Excel Forum Top Contributors:
May 10, 2024
Excel Forum Top Contributors:
How to get X and Y of any point in plot for excel 2010
I have made a scatter plot with a smooth line in Excel 2010.
This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.
Report abuse
Details (required):
Thank you.
Reported content has been submitted
Answer
To get values in between the plotted points, you need the estimated equation of the curve connecting the plotted points. Once again, click on the line and then right-click and then pick:
Add Trendline...
You will need to experiment with the type of line to best match the curve.
Select Display equation on chart
once you have copied the equation into a cell, you can evaluate it for any input.
Report abuse
Details (required):
Thank you.
Reported content has been submitted
83 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Answer
Excel 2010
Generate variable density grid pattern
in background with macro, then
mouse over points to read coordinates.
http://c3017412.r12.cf0.rackcdn.com/02_24_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Generate variable density grid pattern
in background with macro, then
mouse over points to read coordinates.
http://c3017412.r12.cf0.rackcdn.com/02_24_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Report abuse
Details (required):
Thank you.
Reported content has been submitted
19 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated May 7, 2024 Views 154,056 Applies to: