In a second attempt to solve Odelia's question from yesterday, I use a bar of pie chart to automatically move all of the pie wedges less than 4% to a secondary chart. Episode 684 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
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.
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.
