MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 384|Reply: 6

Creating a phasor angles in excel

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 2-11-2017 17:18:06 | All posts |Read mode
Evening all,
I am trying to create a phasor diagram in excel. Like the one below.


I am using the below to get the angles to plot on my graph.
=COS((Q7+th100)*PI()/180)
=SIN((Q7+th100)*PI()/180)
154.376 deg
146.024 deg
140.004 deg
But I also have the length of 8, 16 and 24.

Can anyone advise.
Thank you for your time.
frien_dd
Reply

Props Report

13

Topics

1065

Posts

2355

Integral

King

Rank: 6Rank: 6

Integral
2355
Post on 2-11-2017 19:28:14 | All posts



What are the essential elements of this task? I would expect to draw these kinds of shapes on an XY scatter chart. Since you have angles and lengths (polar coordinates), the first step is probably to convert polar coordinates for each corner of the shapes/polygons into rectangular coordinates used by the XY scatter chart, have those arranged in a way that is easily charted (x coordinates in one column/row and corresponding y coordinates in an adjacent column/row), then create an XY scatter chart from those data. Adding all of the text should be straightforward by adding data labels to various points/series, entering the desired text into the data label, and manually positioning the label in the desired location (this can all be automated, if needed, but it will be a fair bit of programming).
If it helps, here's a tutorial/example I put together illustrating the unit circle http://www.excelforum.com/showthread.php?t=1122215 You can see how I drew two circles by converting the polar coordinates for (r,theta) into (x,y) points. You can also see how I drew the vector to illustrate the angle.
Reply Support Opposition

Props Report

13

Topics

1065

Posts

2355

Integral

King

Rank: 6Rank: 6

Integral
2355
Post on 2-11-2017 21:19:31 | All posts



What are the essential elements of this task? I would expect to draw these kinds of shapes on an XY scatter chart. Since you have angles and lengths (polar coordinates), the first step is probably to convert polar coordinates for each corner of the shapes/polygons into rectangular coordinates used by the XY scatter chart, have those arranged in a way that is easily charted (x coordinates in one column/row and corresponding y coordinates in an adjacent column/row), then create an XY scatter chart from those data. Adding all of the text should be straightforward by adding data labels to various points/series, entering the desired text into the data label, and manually positioning the label in the desired location (this can all be automated, if needed, but it will be a fair bit of programming).
If it helps, here's a tutorial/example I put together illustrating the unit circle http://www.excelforum.com/showthread.php?t=1122215 You can see how I drew two circles by converting the polar coordinates for (r,theta) into (x,y) points. You can also see how I drew the vector to illustrate the angle.











Reply Support Opposition

Props Report

14

Topics

699

Posts

1588

Integral

King

Rank: 6Rank: 6

Integral
1588
Post on 2-11-2017 22:48:13 | All posts



Maybe you can modify one I did previously?








  • phasor diagram (bvj).xlsx
    (16.6 KB, 0 views)
    Download

  • Reply Support Opposition

    Props Report

    14

    Topics

    699

    Posts

    1588

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1588
    Post on 2-12-2017 02:26:34 | All posts



    Maybe you can modify one I did previously?








  • phasor diagram (bvj).xlsx
    (16.6 KB, 3 views)
    Download

  • Reply Support Opposition

    Props Report

    14

    Topics

    699

    Posts

    1588

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1588
    Post on 2-12-2017 03:20:50 | All posts



    Maybe you can modify one I did previously?








  • phasor diagram (bvj).xlsx
    (16.6 KB, 7 views)
    Download















  • Reply Support Opposition

    Props Report

    0

    Topics

    14

    Posts

    34

    Integral

    Member

    Rank: 2

    Integral
    34
    Post on 2-12-2017 04:12:26 | All posts
    Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-21-2017 14:36 , Processed in 0.129381 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!