Results 1 to 9 of 9
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Plot a circle/spiral (2000)

    This has been driving nuts for a little while now.

    I have a created a column of values that will be the various radii lengths of a spiral at a given angle. I would like to XY scatter plot these values radius/angle to depict the spiral and after fruitless hours of searching cannot see how to plot them. I tried a reasonable attempt in VB a while back but it meant splitting the circle into quadrants and using various cos and sin values. I would prefer a one off function that will allow me to plot directly from the sheet...is this possible?
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Plot a circle/spiral (2000)

    Some more info, perhaps, or the worksheet with the data you have?

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Plot a circle/spiral (2000)

    I am trying to plot the Golden Section(see image below).

    In column A I have degrees(0 to 720), column Degrees converted to radians, column C, the Sin () of column B[this may be wrong assumption] and Column D calculates the radius of the spiral at a given angle[formula not required as it is just a numerical value]


    <table border=1><td>Degrees</td><td>As Radians</td><td>Sin(Radians)</td><td>Radius</td><td>1</td><td>0.017453293</td><td>0.999847695</td><td>0.210768058</tr><td>2</td><td>0.034906585</td><td>0.999390827</td><td>0.210918062</td></tr></table>
    Jerry

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Plot a circle/spiral (2000)

    Hi Hans

    I think I may have found something that I can use. I realised I was searching for the wrong thing. I have found this Equiangular Spirals.

    It appears to have what I need to work it out, thanks for your time.
    Jerry

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Plot a circle/spiral (2000)

    Ok, that's fine.

    If someone else still needs it, here is my attempt (attached).

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Plot a circle/spiral (2000)

    What can I say Hans. That is fantastic. I shall compare my values against yours as I have used a different way to calculate my various radii but it is a learning curve <img src=/S/pun.gif border=0 alt=pun width=22 height=18>
    Jerry

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Plot a circle/spiral (2000)

    Hi Hans

    Just as a follow up, I thought I would show you my attempt....same result just using slightly different method to get radii....Thanks once again... I have a big cheesy grin on my face
    Jerry

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Plot a circle/spiral (2000)

    Both methods are basically the same, only I made the spiral go outwards, you made it go inwards.

  9. #9
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Plot a circle/spiral (2000)

    Granted....nothing wrong about our methods they were both correct, just we used slightly different methods to calculate out radii. Thanks, speak to you soon.
    Jerry

Posting Permissions

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