|Originally posted by Trance Nutter |
Surely if you've made any type of chart on excel you could work this out. But lets assume you haven't.
You want 24 segments, so you need 24 pieces of data. They need to be equal size segments, so equal size data.
You then need to colour them clear (so they appear white), which is just the same as modifying data colours on any chart.
in A1 type "1"
grab the expander and pull it down to A24, so you now have 24 "1"'s. Thats your 24 points of data.
Highlight your data.
It should be fine.
Right click on the resulting pie
"Format" or something similar
Fill -> none
click the figure legend and press delete.
Open a blank sheet and press ALT+F11, go to Insert, select "Module", and then paste the following text.
ActiveChart.ChartType = xlPie
MsgBox "suck it"
Then hit the little green "play" triangle.
Then format it