How to graph concentric circles in numbers??

You will have to create several series of data points that go in a circle, chart them with a scatter plot, use curved connecting lines to connect the points, remove the datapoint symbol so all that is left is the circular line, then adjust the size of the chart so the circle is actually a circle. Here is the basic idea of how I would do it

Table 1:

Row 1 is a header row.

Column A = degrees around a circle. 0, 10, 20, 30, ... 360

Column B =COS(A*PI()/180) these are the X values for a unit circle

Column C =SIN(A*PI()/180) these are Y values for a unit circle

For the set of series you want to chart, use another table.

Row 1 is a header row.

B1 = 5 (for example)

C1 = 5

B2=B$1*Table 1:B

Fill down to create the X values.

Fill right to create the Y values.

Do the same thing in the next two columns for the next series, etc.

Chart these two/four/six/whatever columns on a scatter chart as described above.

The formulas are

sin_cos

B2 : =COS(A*PI()/180)

C2 : =SIN(A*PI()/180)

Fill Down

radius

A1 : =MAX(A)

below are the radius of circles to draw.

to chart

A2 : =radius :: $A$1+radius :: $A$2*sin_cos :: $B2

B2 : =radius :: $A$1+radius :: $A$2*sin_cos :: $C2

C2 : =radius :: $A$1+radius :: $A$3*sin_cos :: $B2

D2 : =radius :: $A$1+radius :: $A$3*sin_cos :: $C2

E2 : =radius :: $A$1+radius :: $A$4*sin_cos :: $B2

F2 : =radius :: $A$1+radius :: $A$4*sin_cos :: $C2

G2 : =radius :: $A$1+radius :: $A$5*sin_cos :: $B2

H2 : =radius :: $A$1+radius :: $A$5*sin_cos :: $C2

Fill Down

Select A2…H38

Scatter Chart

Curve line

None point symbol

Yvan KOENIG (VALLAURIS, France) lundi 25 avril 2011 11:28:15

Mine looked like this:

Mine looked like this:

Jerry

I call fake. You have no data. Did you cheat and draw a bunch of circles? Pretty colors, though.

Hi Badunit

I missed the fact that Numbers will automatically move the circles according to the smaller X and Y values of the charted datas.

Given that, your scheme is more efficient than mine.

Yvan KOENIG (VALLAURIS, France) mardi 26 avril 2011 10:45:30

Are you sure that it's a fake ?

Maybe Jerrold hide the values 😉

Yvan KOENIG (VALLAURIS, France) mardi 26 avril 2011 10:46:42

The OP asked how to graph concentric circles, not how to chart data. Fake? Perhaps.

Jerry