Pie Chart- 30 equal 12 degree slices?
 

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!

Pie Chart- 30 equal 12 degree slices?
 

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Pie Chart- 30 equal 12 degree slices?
 

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


"Andy Pope" wrote in message
...
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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Pie Chart- 30 equal 12 degree slices?
 

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


"RW" wrote:


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


"Andy Pope" wrote in message
...
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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Pie Chart- 30 equal 12 degree slices?
 

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.


"Bernard Liengme" wrote in message
...
Paste your chart into a graphics program and play with magnification
--
www.stfx.ca/people/bliengme


"RW" wrote:


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


"Andy Pope" wrote in message
...
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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info