MrExcel podcast is sponsored by Excel-XL.
Excel Charts Chapter 4; Pie Slices Galore.
Hey, welcome back to MrExcel netcast. I'm Bill Jelen.
Well, you know a lot of Pie Charts you see there real nice.
They have 3,4,5 slices and everything works out great,
but in real life, you know just... there's some products that are high flyers,
other products that they're backless, their old, we still keep around.
They sell a few but not enough and so here...
here's a Pie Chart, 4 items really matters,
the rest of the stuff is just, you know tiny little things that no one can really make a lot of sense out of.
so I'm gonna Change this Chart Type,
there are six different Pie Charts to choose from and
I'm interested in here and either something called the Pie of Pie or
the Bar of Pie and I'll choose Bar of Pie and in this particular case,
choose OK and you see what happens is
the Excel decides to keep some of the slices in the major Pie
and then move other slices out to the secondary Axis.
Now I'm not sure what the default is here, but i never liked it.
So I'm gonna right click and
choose Format and we get to control, how to split this.
Do we split it by Position or do we split it by Value or Percentage Value?
All right, so I'm gonna split it by Value and say that
the second plot should contain Values less than let's say a dials
and we click OK.
Take a look at that, click Close.
Okay so, now we have 4 major items in the Pie and then the all other, is all the items less than a 1000.
You have to decide in your data set, what makes the most sense.
And then the next thing is are we really interested in the 4 items
or we interested in the other?
We have a few settings here,
so again I'm gonna go back in the Format Data Series and
we'll take a look at this Pie Explosion,
Gap Width and Secondary Plot Size.
All right, so we can go to a really small Secondary Plot Size
compared to the Pie and then you know it's hardly visible at all
or sometimes you might be interested in
those all other items and
so we can make them even larger than the primary Pie,
so we can see the details.
Your call, as far as what we want
to do there?
It also can control the Gap, the amount of gaps between the Pies and
also whether they are Together or Separate.
Now watch out for this Pie Explosion setting,
it is not zero, it's always resets to zero.
This is a bug in this dialog box, so if I said that the 76,
wanna come back in later, it is going to
pick up.
All right, hey, there you have a cool way
to take all those small slices...
Hey, thank you for stopping by.
We'll see you next time for another netcast MrExcel.
