Making a circle with numbers

[Usercode]

Is there a way to make a perfect circle with numbers in excel? Lets say if I choose 40 numbers, from 1 - 40 numbers will be arranged in a perfect circle in an excel sheet. I mean the distances between numbers should be same and all. and if I choose 60 numbers, it will be a little bigger circle again, etc. thanks.

 

[oldbrewer]

look at creating a circle chart and make the segment lines invisible ?

 

[Usercode]

thanks for your suggestion. but I'm looking for a way to spread the numbers across the cells in circle

 

[oldbrewer]

so for a 5 number circle a10 contains 1, c13 contains 2 etc ?

 

[Usercode]

yes, it can be anywhere on the sheet according to the size.

 

[oldbrewer]

it would take a lot of work to do it with formulas, a macro would be best - but - why cannot you use a segmented pie chart with segments and outer circle "hidden".

Perhaps if you told us WHY you want to do this, there might be another way.

 

[Usercode]

Thanks, oldbrewer. The thing is I need this in cells. I can do this by hand, and I do it but it is far from being a circle, and it still takes a lot of time to arrange it. I need it for a game and teaching.
I am not sure if its possible to do it on excel, just wanted to ask here to see if there is a way. I agree, it'd definitely require a macro.

 

[oldbrewer]

for 5 numbers let number 1 have the coordinates x=20 , y=0
so cell T1 can be your start point

number 2 coordinates are x=20 +5 sin 18 y=0 + 5 sin 72

a circle of radius 5 contains the pentagon and simple trignometry gives the location of point 2

5 sin 18 = 1.55 so x for number 2 is 21.55 say 2 cells to the right
5 sin 72 = 4.75 so y for number 2 is minus 4.75 or say 5 cells down

I think using common sense and symmetry you can determine the next 2 numbers' positions

 

[Usercode]

Thanks, Oldbrewer.