Excel - Charts and Graphs - Too Many Slices: Episode 1287

Microsoft Excel Tutorial: Too many pie slices in a chart.

Welcome to the MrExcel podcast. In this episode, we will be discussing Excel charts and graphs, specifically the issue of having too many slices in a pie chart. I'm Bill Jelen and I'll be your host for today's netcast.

Pie charts are a popular way to visually represent data, but in real life, things are not always as simple as having 3 or 4 slices. Some products may be top sellers while others are barely making any sales. This can result in a pie chart with a few significant slices and a bunch of tiny ones that are difficult to make sense of. That's where the Pie of Pie and Bar of Pie options come in.

To access these options, simply right-click on the pie chart and choose "Format." From there, you can select either Pie of Pie or Bar of Pie. This will split the smaller slices into a secondary axis, making it easier to see the important data. However, the default settings may not always be ideal, so you can further customize the split by choosing to split by position, value, or percentage value.

Another important aspect to consider is the size and gap of the secondary plot. You can adjust these settings in the "Format Data Series" dialogue box. This allows you to control the visibility of the smaller slices and decide whether you want to focus on the main items or the smaller ones. Just be careful with the "Pie Explosion" setting, as it has a tendency to reset to zero.

So there you have it, a simple yet effective way to deal with too many slices in a pie chart. As always, thank you for tuning in to the MrExcel netcast. We hope you found this episode helpful and we'll see you next time for more Excel tips and tricks. Don't forget to subscribe to our channel for more informative content.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...

Table of Contents:
(00:00) Pie Chart with Many Tiny Slices
(00:12) Real Life Pie Charts
(00:22) Changing Chart Type
(00:41) Choosing Bar of Pie
(01:02) Formatting the Split
(01:31) Adjusting Settings
(02:19) Controlling Gap and Explosion
(02:47) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
how to make a pie chart in excel with bar of pie
how to do bar of pie chart excel
how to make make pie and bar graph in excel from data
how to make bar of pie chart excel
how to create bar of pie chart in excel
how to make a bar of pie chart in excel
how to add pie of pie in excel pivot chart
how to do a pie of pie chart in excel
how to draw pie of pie charts excel
how to make a pie of pie chart excel
how to make pie of pie chart larger in excel
how to pie of pie chart excel
how to use pie of pie chart excel
how to use pie of pie chart in excel
how to visualize pie of pie chart in excel
how to format pie of pie excel
how to do a pie of pie in excel
how to make pie of pie diagram in excel
how to use excel pie of pie
how to use pie of pie excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...

Today, in Episode #1287, Bill looks at the dilemma of too many slices cluttering your Pie Chart and shows you how to move those smaller slices to their own Chart within the same graphic display. "Charts And Graphs:Microsoft Excel 2010" by Bill Jelen.