ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I calculate the angle between two lines on a chart (https://www.excelbanter.com/charts-charting-excel/119040-how-do-i-calculate-angle-between-two-lines-chart.html)

R.Swipe

How do I calculate the angle between two lines on a chart
 
I'm trying to calculate the angle between a Target Line and a Trend Line
(both are straight lines) on a chart. Any ideas as to how I would do this?
Thanks

Bernard Liengme

How do I calculate the angle between two lines on a chart
 
SLOPE is a measure of the angle a line makes to the x-axis
So slope2-slope1 is proportional to the angle between two lines
Now do your homework
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"R.Swipe" wrote in message
...
I'm trying to calculate the angle between a Target Line and a Trend Line
(both are straight lines) on a chart. Any ideas as to how I would do this?
Thanks





All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com