Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Let's try a second stab at solving Delia's problem from yesterday.
She needed to create a pie chart of just the items greater than four percent and yesterday
I use the filter to do that but today we're going to take a look at a different type of chart.
If we go into Pie, there's two. It's called pie a pie and borrow pie.
They both work basically the same, so I'm gonna, it really doesn't matter.
I'm going to choose either one, click Next. In step 3, I wanna turn off the legend
and on the data label show Category name and Value and click Finish.
Now, here's what happens anything that is below a certain threshold
gets put into one wedge called other and then it's detailed out here on the right-hand side.
I'm going to right-click anywhere in the pie format data series and we can change the default.
So, I'm going to split this not by position, but by a percentage value
and say that the Second plot contains all values less than 4 percent
that automatically moves anything less than 4 percent out there
and the other thing we can do is we can control the size of that.
If you really don't even want that to show, we can just take it down to practically nothing.
So, it'll be very unobtrusive
gap with we can set the gap with a fairly high to make sure that the labels,
try not to get on top of each other here. Let me actually take this down to zero
and the gap with set to the maximum, Click OK.
I can imagine
there would be a situation where you could actually just kind of hide this
out here with a nice white box and no one would
even know that it's there not the best solution in the whole world,
to get rid of those leader lines that are going between the series
Format Data Series, it was an option here called Series lines
you know so we could format that box that way it didn't have
a border around it Format auto Shape line none,
click OK.
and you start to get to something relatively close.
The advantage of this is that as the numbers change.
we don't have to recalculate the threshold Excel does that force of automatically.
So, if this number would become
1,400, I have to resize the name of the box  but
items will automatically go from one box to the other based on the size.
So this might be a little bit better the big advantage of this is that we show
that other slice in the method from yesterday, everyone under 4 percent just disappears from the chart.
So, we can see the size of the entire Pie.
Thanks to Delia for sending that question in.
Thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.
