Pie in Pie Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gracie - 05 Nov 2003 23:17 GMT

Excel 2002 I would like to know if it's possible to
display the results of a year's 4 quarters in one pie
chart and then break one of the four monthly totals in
the little chart. No matter what I do, it seems to total
them all together and without reason it will place some
of the information in one pie chart and some of it in the
little chart. Here is some sample data:

4th Quarter    $16.10
3rd Quarter    $1.20
2nd Quarter    $1.03
1st Quarter    $22.20

January    $13.40
February $6.20
March    $1.10
April    $1.50

Reply to this Message

Debra Dalgleish - 05 Nov 2003 23:34 GMT

I'm confused by your data, as each quarter should only include three
months, but your first quarter total is equal to the sum of Jan-April.

To create a pie of pie chart for the three months, and the remaining
quarters, remove the 1stQuarter line and the April line. The revised
data is:
4th Quarter $16.10
3rd Quarter $1.20
2nd Quarter $1.03
January $13.40
February $6.20
March $1.10

Use the Chart Wizard to create a pie of pie chart from this data.
Then, click on one of the pies, to select the series.
Choose Format>Selected Data Series.
On the Options tab, choose to split series by Position.
Second plot contains the last 3 values
Click OK

> Excel 2002 I would like to know if it's possible to
> display the results of a year's 4 quarters in one pie
[quoted text clipped - 13 lines]
> March $1.10
> April $1.50

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Gracie - 06 Nov 2003 00:48 GMT

Okay, so where is the options tab located?

>-----Original Message-----
>I'm confused by your data, as each quarter should only include three
[quoted text clipped - 34 lines]
>> March $1.10
>> April $1.50

Reply to this Message

gracie - 06 Nov 2003 00:49 GMT

That worked Great, thank you.

>-----Original Message-----
>I'm confused by your data, as each quarter should only include three
[quoted text clipped - 34 lines]
>> March $1.10
>> April $1.50

Reply to this Message