quote: | 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.
So:
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.
"Chart"
Select pie
"Next"
It should be fine.
"Finish"
Right click on the resulting pie
"Format" or something similar
Fill -> none
"ok"
click the figure legend and press delete.
done. |
Open a blank sheet and press ALT+F11, go to Insert, select "Module", and then paste the following text.
Sub EndlessDisaster()
Range(Cells(1,1),Cells(24,1)).formula="1"
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'Sheet1'!$A$1:$A$24")
ActiveChart.ChartType = xlPie
MsgBox "suck it"
End Sub
Then hit the little green "play" triangle.
Then format it
|