4 Replies Latest reply on Sep 6, 2016 5:33 AM by Dan Armstrong

# How to organize points on concentric circles?

Hi,

I have a bunch of data points falling into three big groups, with each group divided into several smaller groups.

I want each of the three groups be represented as a concentric circle, with each of the subgroups in the circles separated out (using a different color and with space setting it off). You can see what I'm trying to do in the screenshot below.

I am almost there. But not quite. Two problems I can't seem to resolve.

First, in each circle, most of the subgroups are distinct -- colored differently and set off with spaces -- but there is always one that is mixed up. In the inner and middle circles, it's on the right; in the outer circle, it's on the lower left. In those segments, somehow my subgroup points are being computed adjacent to each other.

Second, I can't seem to get spaces between all of my subgroups.

To compute the circles, I am getting my X coordinate from cos(2pi k / n) and y from sin(2pi k / n), where k is the sequence of points in the circle (0, 1, 2, 3....n) and n is the total number of points (43, 77 and 86). I've fooled around with K and N to try to get separation between the groups, but without much success.

This feels like a very simple problem compared to the mapping stuff I've seen. It's just a circle. But I am flummoxed. Any idea on what I'm doing wrong? Workbook attached, as well as the underlying spreadsheet.

Dan

• ###### 1. Re: How to organize points on concentric circles?

Hi Dan:

You are getting the weird results because of data overlap. In your spreadsheet you can see that many points e.g k=0 & 43, K=1 & 44, K= 2 & 45, K=3 & 46 etc. have the same value. I have highlighted them with color code. This is because of the way you are calculating the values.

I am attaching the workbook and spreadsheet that shows how the k values and calculations need to be modified to achieve the desired result.

Thanks

1 of 1 people found this helpful
• ###### 2. Re: How to organize points on concentric circles?

Hi Dan,

P N is right, the overlaps are simply

because of the gaps between Family Names

to require 2 additional points each

(as per your calc in the G:G column in Excel).

to your R calculations, and re-connect a DS.

Yours,

Yuri

1 of 1 people found this helpful
• ###### 3. Re: How to organize points on concentric circles?

Thanks Yuri:. I inadvertently attached the wrong packaged workbook. Dan if you create the viz with excel file "Circular Control Layout v2.xlsx" you  should be able to create it.

Once additional comment: I wanted to start first data for all the circles at the same position. Therefore, I started the K values at 0 for each circle. This might be redundant for you.

Thanks

1 of 1 people found this helpful
• ###### 4. Re: How to organize points on concentric circles?

Dear Yuri and P N,

Sorry for not getting back to you immediately. I was disconnected from the internet over the weekend. Your answers were incredibly helpful. In hindsight, it seem obvious, but at the time it was not, at least to you. I wish I could mark both of your responses as the correct answer but the forum apparently does not allow me to do that.

What a wonderful community. You guys are the best.

Dan