View original (French)

Coordinates of a point on an Excel curve

Solved
SABHARZALI Posted messages 21 Status Membre -  
SABHARZALI Posted messages 21 Status Membre -
Hello,
I just plotted a 2D line graph based on data from an Excel 2007 table.
I would like to position myself on the curve, choose any point, and return its coordinates by projecting it onto the x-axis and y-axis.
Thank you in advance for your help.

2 réponses

Réponse 1 / 2
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
Sliders are not part of the Excel chart tools.
With a standard curve, it's impossible since the x values are just labels and not proportional.
With a scatter plot, it is possible to represent two sliders with a calculation based on interpolation. (ccm81 file if I remember correctly)
3
SABHARZALI Posted messages 21 Status Membre
 
Thank you for your collaboration, even though I didn't quite understand the last sentence.
0
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064 > SABHARZALI Posted messages 21 Status Membre
 
It’s not a real cursor that you move with the mouse.
You choose or increment a value of x and two lines follow the values of x and y.
0