Voltage/Current vector charting

How do I graph vector showing length and direction?
(120 volts@ 0 degrees, 120 volts @ 120 degrees & 120
Volts @ 240 degrees).
These vectors originate at the intersection of the X &
Y axis.

Hi Kraig,
For each vector you need two point
x y
0 0
Vsin(angle) Vcos(angle)

Remember, Excel expects angles in radians. So if the voltage is in A1 and
the angle is in B1, for the second pair of points use
=A1*SIN(RADIANS(B1)) and = A1*COS(RADIANS(B1))

Select the three row (row one has headings X and Y); click the chart wizard,
select an XY chart.

Bernard
www.stfx.ca/people/bliengme

"Kraig" wrote in message
...
How do I graph vector showing length and direction?
(120 volts@ 0 degrees, 120 volts @ 120 degrees & 120
Volts @ 240 degrees).
These vectors originate at the intersection of the X &
Y axis.

[This followup was posted to microsoft.public.excel.charting and a copy
was sent to the cited author.]

Convert the R-theta values into x and y coordinates with the formulas
x=R*cos(theta) and y=R*SIN(theta), where theta is measured in radians.
To convert degrees to radians, use Rads=Degs*Pi()/180.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office


In article ,
says...
How do I graph vector showing length and direction?
(120 volts@ 0 degrees, 120 volts @ 120 degrees & 120
Volts @ 240 degrees).
These vectors originate at the intersection of the X &
Y axis.