If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Voltage/Current vector charting
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. |
#3
|
|||
|
|||
Voltage/Current vector charting
[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. |
Thread Tools | |
Display Modes | |
|
|