stramvaier
02-14-2019, 08:47 AM
Hi. i am trying to automatically draw a 90degree triangle in my excel sheet based on the unit value in 3 cells. i dont know if its possible so i ask here for help.
i have calculated the unit value for leg_a using cosinus of the angle between leg_a and hyp_c (converted from radians to degrees) and hypotenuse unit lenght(A5).
I will allways know these values (angle and hyp)
I then use phytagoras for leg_b, standard math.
This gives me the correct unit distance for each side, but i cant find how to make a triangle in my worksheet based on the value i have in these cells:
A5=hyp_c, E5=leg_a, F5=leg_b.
23746
I would also like the triangle to be dynamic so as when i change the values in my cells the triangle would change also.
anyone have a good idea to help me?
Any help is appreciated.
i have calculated the unit value for leg_a using cosinus of the angle between leg_a and hyp_c (converted from radians to degrees) and hypotenuse unit lenght(A5).
I will allways know these values (angle and hyp)
I then use phytagoras for leg_b, standard math.
This gives me the correct unit distance for each side, but i cant find how to make a triangle in my worksheet based on the value i have in these cells:
A5=hyp_c, E5=leg_a, F5=leg_b.
23746
I would also like the triangle to be dynamic so as when i change the values in my cells the triangle would change also.
anyone have a good idea to help me?
Any help is appreciated.