View original (French)

Coordinates of a point on an Excel curve

Solved
SABHARZALI Posted messages 21 Status Member -  
SABHARZALI Posted messages 21 Status Member -
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 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member 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
    1. SABHARZALI Posted messages 21 Status Member
       
      Thank you for your collaboration, even though I didn't quite understand the last sentence.
      0
      1. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064 > SABHARZALI Posted messages 21 Status Member
         
        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