+ Reply to Thread
Results 1 to 5 of 5

Creating a phasor angles in excel

  1. #1
    Registered User
    Join Date
    02-10-2017
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    Creating a phasor angles in excel

    Evening all,

    I am trying to create a phasor diagram in excel. Like the one below.
    Untitled.png

    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

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Creating a phasor angles in excel

    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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Creating a phasor angles in excel

    Maybe you can modify one I did previously?
    Attached Files Attached Files
    Ben Van Johnson

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Creating a phasor angles in excel

    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  5. #5
    Registered User
    Join Date
    02-10-2017
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    Re: Creating a phasor angles in excel

    Thank you for you help.

    I have modified protonLeah's example.

    Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Looking for a phasor center pivot 3 phase voltage/current
    By Steve Fairbanks in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-15-2016, 02:57 PM
  2. Plotting AC Power Phasor Diagrams in Excel
    By aharb in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 05-15-2016, 09:58 AM
  3. Can Excel Draw Shapes or Angles based on Data?
    By chesspupil in forum Excel General
    Replies: 15
    Last Post: 04-30-2016, 03:31 PM
  4. Bearings and angles in Excel
    By GingerAngles in forum Excel General
    Replies: 2
    Last Post: 02-05-2016, 10:16 AM
  5. Replies: 1
    Last Post: 12-16-2015, 09:57 AM
  6. [SOLVED] Angles
    By smartie123 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2006, 08:55 PM
  7. How to do I convert angles from radians to degrees in Excel?
    By HELP ME PLEASE!!!!! in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2006, 03:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1