If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pie of pie problem
I am trying to create a "pie of pie" chart, with the following data
A 1 2 B 66.3 I C 33.3 II D 10 sectionA E 10 sectionB F 10 sectionC G 3.3 sectionD I am looking for a primary pie with only pieces I & II, with the secondary pie being the "explosion" of piece II (including sectionA - sectionD). As you can see, pieces I & II sum to 100 and sectionA - sectionD sum to 33.3 (piece II). Basically, I want to show the composition of piece I and II. Thanks, Tom -- Cheers, Tom G. to send me e-mail, please remove the "123" from my return address, and substitue "tgu" |
#2
|
|||
|
|||
pie of pie problem
set your data up like this:
red B 66.3 D 10 E 10 F 10 G 3.3 (do not include the 33.3) after you select the pie of pie chart option, format data series and go to options. Split series by position, 4 in the split slice. Tom G wrote: I am trying to create a "pie of pie" chart, with the following data A 1 2 B 66.3 I C 33.3 II D 10 sectionA E 10 sectionB F 10 sectionC G 3.3 sectionD I am looking for a primary pie with only pieces I & II, with the secondary pie being the "explosion" of piece II (including sectionA - sectionD). As you can see, pieces I & II sum to 100 and sectionA - sectionD sum to 33.3 (piece II). Basically, I want to show the composition of piece I and II. Thanks, Tom -- Gary Klass Editor, PSRT-L 4600 Politics and Government Illinois State University Normal, Illinois 61790 http://LILT.ILSTU.EDU/gmklass (309) 438-7852 (fax) 438-7638 The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow |
Thread Tools | |
Display Modes | |
|
|