Pie Chart- 30 equal 12 degree slices?

[RW]

Can someone tell me how to make Excel draw a pie chart with 30 equal
segments?

What I'm trying to do is layout 30 tic marks every 12 degrees around the
perimiter of a circle and this seems like it might work.

Thanks!

 

[Andy Pope]

Hi,

Select the range A1:A30. Enter 1 and commit using CTRL+ENTER.
You can then create a pie on that range.

If you want a circle with ticks on the circumfrence that a radar chart
is better. Format the line to have no border with a + marker.
Format the value axis to have a Major unit value of 1.

Cheers
Andy

 

[RW]

Andy,

Thanks a million! This technique worked great and I was able to make a small
template to mark the face of my 3" diameter cylinder.

Using the same data, I then created a single line chart to tape onto the
outside of the cylinder to help me mark the same 12 degree divisions around
the circumference. So other than trial-and-error, is there a way to make my
line chart span an exact value in inches? In this case it's 9.424".

There is a "ruler" option but I can't select it because it is always
grayed-out.

Thanks again,

DS

 

[Bernard Liengme]

Paste your chart into a graphics program and play with magnification
--
www.stfx.ca/people/bliengme

Andy,

Thanks a million! This technique worked great and I was able to make a small
template to mark the face of my 3" diameter cylinder.

Using the same data, I then created a single line chart to tape onto the
outside of the cylinder to help me mark the same 12 degree divisions around
the circumference. So other than trial-and-error, is there a way to make my
line chart span an exact value in inches? In this case it's 9.424".

There is a "ruler" option but I can't select it because it is always
grayed-out.

Thanks again,

DS

 

[RW]

Thanks for the suggestion but I thought of an even better trick. Using
Microsoft Publisher I created a 9.424" wide, 30 column table. Added borders
for each cell, printed it (landscape mode), taped it to the cylinder, and it
was perfect.

Paste your chart into a graphics program and play with magnification