Finding true angle on a plot?

spacely

Board Regular
Joined
Oct 26, 2007
Messages
245
Hi,

Maybe this isn't an excel question, but perhaps you can help?

How do we determine the angle between 2 plots (of a line), where the x-axis and y-axis has completely different Units and Scale? The arctan function requires a unitless argument to get a real angle, but if you take rise/run on a plot with completely different axis units, it won't be unitless.

Maybe someone worked this out already?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,424
Office Version
  1. 2010
Platform
  1. Windows
Hi,

Maybe this isn't an excel question, but perhaps you can help?

How do we determine the angle between 2 plots (of a line), where the x-axis and y-axis has completely different Units and Scale? The arctan function requires a unitless argument to get a real angle, but if you take rise/run on a plot with completely different axis units, it won't be unitless.

Maybe someone worked this out already?

The ArcTan function returns a unitless value, but the two numbers you divide are not unitless, they just need to have the same unit for both. So, if you have two different units, you need to convert the number for one unit to its equivalent value in the other unit and then divide those two numbers. You did not tell us what the two units you have are, so I cannot give you any more detail than what I did above.
 

spacely

Board Regular
Joined
Oct 26, 2007
Messages
245
Yes, and now I realize that the conversion used for one of the lines better be the same as used to convert ALL the lines with which we compare angles on that same plot. A different "conversion" per line is wrong, if they share the same plot :)

Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,236
Messages
5,546,656
Members
410,753
Latest member
Ian R
Top