# Thread: Plot a circle/spiral (2000)

1. ## 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?

2. ## Re: Plot a circle/spiral (2000)

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

3. ## 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]

4. ## 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.

5. ## Re: Plot a circle/spiral (2000)

Ok, that's fine.

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

6. ## 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>

7. ## 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

8. ## 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. ## 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.

#### Posting Permissions

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