View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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