Drag and drop a line, then auto calculate value with Pythagorean theorem

[DashboardNovice]

See 1:20 on this video.

Watch Youtube Video

Does Excel have a graphing feature which will let me:

1. Allow me to define the range of X axis values (I would use only positive numbers)
2. Allow me to define the range of Y axis values (I would use only positive numbers)
3. Click a point, drag and drop to another point, then automatically calculate the value of that line (the hypotenuse) using Pythagorean theorem

I know points 1 and 2 are possible, but I don't know about point 3. Is there a feature in Excel that can do this, or maybe an add-in or a plug-in?

If not, is there a software program (ideally one that is free) that can do this?

 

[Hui]

How about this?


To use
Set the X and Y Axis Maximum Values
The Chart will rescale after you type each value

Set how many decimals you want in the solution
Select the chart and then click on the Red line
Drag the ends to where you require
Click the Calculate Button
Enjoy


See attached file ?