# making circles

#### janus67

##### Board Regular
I would like to make up a circular diagram with numbers in the circular cells.

the diagram would be a series of concentric circles (about 6 of the same separation apart) and divided into cells by about 12 diagonal lines radiating from the centre to the outside circle.
essentially, it looks like a " wheel with spokes " or a carriage wheel

I looked at pie charts etc but don't know if this is the answer.

could anyone advise please if I can do this in Excel and if so, where/how I can start on it

thanks Keith

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### janus67

##### Board Regular
I think the Polar charts can be adapted to do the job

#### roscoe

##### Well-known Member

This one does something awfully close to what I need...

I envision six rings (for example), each of which is subdivided into 8 equal parts (i.e. each slice is 45 degrees), with the color of each slice based on the value of that slice.

Specifically, I'm measuring the effect of 6 different systems on the performance of a central system, measured from 8 different azimuths around that central system.

Each of the six systems will be a ring in the donut, and each slice will be one of the eight azimuths. The color of each slice then is conditional based on the results (i.e. if the central system performed better than 80% when exposed to System A from 45 deg, the slice will be green, less than 60% is red, and anywhere in between is yellow).

Make sense?

I can make the rings subdived in 45 deg chunks generating 8 rows of data and setting their values equal. However, I can't figure out how to make their color based on a nother value.

Is this possible?

#### janus67

##### Board Regular
thanks Roscoe, that's the same site as PaddyD mentioned --am working on it

Keith

Replies
5
Views
516
Replies
0
Views
504
Replies
7
Views
488
Replies
8
Views
2K
Replies
0
Views
1K

1,195,582
Messages
6,010,578
Members
441,557
Latest member
Jbest23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back