Pie of pie charts - how to set up data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RichN - 02 Nov 2006 22:31 GMT

I'm just trying this kind of pie chart for the first time.

Example: I have 408 people in my company 401K. Of these, 38 joined in
2006, the other 370 joined in 2005.

Of these 38 - 29 get company match, 9 don't.

Is this the kind of info I can show in a pie of pie?

Reply to this Message

Jon Peltier - 02 Nov 2006 23:01 GMT

Rich -

The 38 are combined in the main plot but shown as individual wedges in the
secondary plot. Arrange the data like this:

2005 371
match 29
no match 9

Select the range and make the pie-of-pie chart. It initially only puts the
no match data into the separate pie; double click on any of the wedges, and
on the Options tab of the Format Series dialog, make sure these settings are
selected:

Split by: Position
Second Plot Contains the Last: 2 values

If you apply data labels to the chart, the merged match + no match wedge in
the main chart has the label "other", which you can select and edit to say

>2006".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> I'm just trying this kind of pie chart for the first time.
>
[quoted text clipped - 4 lines]
>
> Is this the kind of info I can show in a pie of pie?

Reply to this Message