Hi I am trying to create a (x,y) chart on a scatter or radar to plot 3 values (electrical vectors)
Magnitude | Direction
30 | 60 degrees
60 | 150 degrees
90 | 270 degrees
any number really, but basically , the origin is 0, and the endpoint is 30. that's the easy part, but excel doesn't have a "compass - 360 degrees" chart that I can plot the direction of these values on.
could anyone lend a hand in this?
any help is appreciated
x = magnitude * cos(radians(angle))
y = magnitude * sin(radians(angle))
Entia non sunt multiplicanda sine necessitate
Hi,
Use some basic coordinate geometry to determine the Cartesian horizontal (x) and vertical (y) components from your polar coordinates.
Regards
attached has basic chart, sheet2, using formula.
output on sheet1 was generated using my free addin for polar plotting
http://www.andypope.info/charts/polarplot3.htm
thats great. this is very well done. thanks for the reply!
ive been playing around with it and is there any way to get the graph counter clockwise with 0 on the hoizontal axis on the right, and 90 degrees vertical?
thats great. this is very well done. thanks for the reply!
ive been playing around with it and is there any way to get the graph counter clockwise with 0 on the hoizontal axis on the right, and 90 degrees vertical?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks