Split Pie Charts

[bvc]

I'm trying to insert a pie chart that sections off and shows 2nd pie with a different set of data. Is that possible and, if so, how do I do that?

 

[Mark W.]

I believe you're describing a pie-of-pie chart. See the 3rd subtype of the Pie Chart Type.

 

[bvc]

I have tried that, however i'm trying to figure out how to designate a set of data as the 2nd pie. Every time i've set it up, the 2nd pie is simply a complete pie rather than another breakdown of a second set of data. Any suggestions?

 

[Mark W.]

Plot this using pie-of-pie subtype... and, take a look at the Help topic for "Change the points plotted in a pie-of-pie or bar-of-pie chart".

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Blueberry	10
2	Cherry	20
3	Apple	30
4	Mincemeat
5	raisins	10
6	apples	15
7	spices	20
8
9
Sheet2

This message was edited by Mark W. on 2002-09-17 12:58

 

[bvc]

so in order for the excel to recognize a subset, there must be a cell between the two sets of data. very cool. thanks! you're a rock star.

 

[Mark W.]

Yeah, Mick and I "hang out" together all the time.

 

[bvc]

One more question to the rock star, if you don't mind.

I'm trying to plot the chart, however whatever It's not splitting the proper piece of the pie. I've pasted the information that I would like to chart (A-E in the 1st pie and 1-5 in the 2nd), and left the space in E, however, the problem persists that E is an entity of its own and "1"is also in the 1st pie, which plots 2-5 as part of the 2nd pie. Does that make sense?

Nevermind, I just figured it out. Thanks.
This message was edited by bvc on 2002-09-17 13:47

 

[Mark W.]

I guess I'm gonna eat some humble pie. The pastel colors that Excel assigned to my earlier example lead me to believe that you do leave an empty cell... But you don't! So, your "E:" slice will be labelled "Other". Be sure and follow the instructions in the Help topic that I posted earlier. You'll need to designate the last 5 entries as the pie-of-pie values.

 

[bvc]

Gotcha! I was wondering why I kept coming up with an "other".

So now the question is, how does one designate "E" in the legend, as there is no label for "other" in the legend?

Btw, your friend, Mick, was just in town with the Stones this past weekend and played across the street from my office last night.

 

[Mark W.]

I'd ditch the legend, display data labels via the Format | Selected Data Series... menu command, select the text box containing "Other", and overwrite it with "E:".