Excel Find length of side of triangle in Excel

J

JSK

Joined
Sep 13, 2017
Messages
8
Reaction score
0
Hi i am Jo

would need help in finding the length of the third side of a triangle in excel

I have three points number: AB- 235 BC- 156 need to find length AC - it's not a right angle triangle,
 
Welcome to the forums Jo.

Having the length of two sides of a triangle isn't enough to calculate the length of the 3rd side, for a non right-angle triangle. You'll also need to know one of the angles.
 
Ian said:
Welcome to the forums Jo.

Having the length of two sides of a triangle isn't enough to calculate the length of the 3rd side, for a non right-angle triangle. You'll also need to know one of the angles.
Click to expand...

Thanks Iain for getting back/
Iain and i am trying to format it in Excel, isn't it possible based on the chart where it has an X and Y axis too
 
I don't understand what you mean unfortunately - can you please take a screenshot of the problem, as that may help me see what you're trying to achieve :).
 
I have drawn lines in excel, any options in excel where it can evaluate the axis and evaluate the length of the third side.
Eg: if i draw the same line in the piece of paper it's easy. anything possible in excel.
 

Attachments

  • 3 POINTS.webp
    3 POINTS.webp
    8.7 KB · Views: 108
What's the X axis measurements? It just says 1,2 and 3 - which I guess isn't a real value (or is it)? Your "triangle" has lines that cross almost 200 units on the Y axis, but only 1 or 2 units on the X axis.

Is this data coming from cells somewhere?
 
i have got the data in excel and have drawn a line chart, and need to find the line "AC"
 
I don't know what A, B and C are - it's just numbers. AB is the difference between A and B, but isn't the line length on that graph you've drawn, it's just the difference in height. Same for CB.

If you can explain where you've got this from, I may be able to help.
 
Ian
EG: DJI daily data the analysis formulates the base high /low and buy /sell prices
setting targets and stop loss. the base high low is flowing in a triangular format, to analyse it better I am after the third line. attached is the pic . its very good I believe
 

Attachments

  • DJI.webp
    DJI.webp
    203.9 KB · Views: 149
the previous one has not been formalised? this is the correct one
 

Attachments

  • DJI.webp
    DJI.webp
    183.9 KB · Views: 156
Sorry @JSK, I'm not sure how to do what you're asking as don't see how it's possible to calculate the numerical length with that information - it may be worth asking some traders, as it sounds fairly specific to that. Sorry I can't be of more help.
 
Thank Ian for your time and reference. I was thinking more from the maths point of view, doesn't matter stocks or just normal length. :)
 
Back
Top