Pie of Pie Chart - Correct input of data

C

Christine

I am trying to put together a pie of pie chart, but I
can't seem to figure out the order in which I need to
input the data so that the smaller pie depicts the slice
of the big pie that I want it to. I keep getting
an "Other" slice, and have no idea where it's coming
from. Anyone?
 
D

Debra Dalgleish

Your data should include the values for the slices that you want in the
large pie, excluding the "Other" slice, and the values you want in the
small pie.

For example:
Region A 200
Region B 300
Region C1 50
Region C2 80
Region C3 20

Use the Chart Wizard to create the Pie of Pie chart, then click on one
of the slices, to select the series.

Choose Format>Selected Data Series
On the Options tab, select an option from the 'Split series by'
dropdown. (In this example, choose Position)

From the next dropdown, choose a setting for the second plot. (In this
example, choose last 3 values)

Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top