Pie of Pie Chart - Correct input of data

  • Thread starter Thread starter Christine
  • Start date Start date
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?
 
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
 
Back
Top