Circles in Circle 1

[Visio Guy]

Align circles around the inner edge of a larger circle...without ShapeSheet or code!

Circles in Circle 1

[kharkaltar]

Hello,

You can also use math to find the radius of the smalls circles.
r = smalls circles radius
R = large circle radius
g = angle = 360/Number-of-circles

r = R*SQRT((1 -cos(g))² + sin(g)²) / (2 + SQRT( (1 – cos (g))² + sin(g)²))

See attached VSD file.

First page is the math formula described
second page is an example of an automated set of circles.

regards,
Jerome.

[vojo]

cool

smells like a macro to create on the fly

maybe even all shapesheet for up to say 10 circles (hide unused based on small circle count).

But cool

Curiously, where did you find info on the math involved?

[Visio Guy]

You guys are reading my mind!

When I worked out the small-circle radius a few days ago, I wound up with something simpler:

r = RSinA2/(1 + SinA2)

A2 is 1/2 of "A1". A1 is 360deg/Ct, which is kharkaltar's "g"

[wapperdude]

Yep!  Both formulas give same value.  Both blow up for count = 1.  OK.  That's a degenerate case!

Note.  Most literature gives the radius of larger circle in terms of unit radius of smaller circle.  Well, technically, diameters, but the formula is unchanged.
Attached Excel file computes both formulas.  Allows user to enter a value for the small circle radius.

Wapperdude