pie of pie problem

  • Thread starter Thread starter Tom G
  • Start date Start date
T

Tom G

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"
 
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 said:
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
Click to expand...

--
Gary Klass
(e-mail address removed)
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
 
Back
Top