How to move the small slices from a busy pie chart to their own chart.
Transcript of the video:
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.
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.
