Excel - Excel Charts 4 - Too Many Pie Slices - Episode 1211.404
7 هزار بار بازدید -
14 سال پیش
-
Microsoft Excel Tutorial: Excel Charts
Microsoft Excel Tutorial: Excel Charts 4 - Too Many Pie Slices.
Welcome back to another episode of the MrExcel netcast, sponsored by Excel-XL. In this chapter of our Excel Charts series, we will be discussing the common issue of having too many pie slices in our charts. While pie charts may look visually appealing with 3 or 4 slices, in real life, there are often products or categories that are not as significant and can clutter the chart. So, let's dive into how we can effectively manage this problem.
To start off, we have a pie chart with 4 important items and a bunch of smaller, less significant items. We can easily change the chart type by selecting the chart and going to the Chart Design tab, then clicking on Change Chart Type. From here, we have the option to choose from 6 different types of pie charts. In this case, we will select either the Pie of Pie or Bar of Pie chart. These options allow us to move some of the smaller slices to a secondary axis, making the chart more manageable.
Once we have selected the Bar of Pie chart, we can right-click on the chart and choose Format Data Series. This gives us control over how the slices are split between the main and secondary axis. We can choose to split them by position, value, or percentage value. In this example, we will split them by value and set the second plot to contain values less than a certain amount. This allows us to focus on the 4 main items in the pie chart and have a separate bar chart for the smaller items.
But that's not all, we can also adjust the pie explosion, gap width, and secondary plot size to further customize our chart. The pie explosion setting controls how much the smaller slices are separated from the main pie, while the gap width determines the spacing between the pies. We can also choose to have the pies together or separate. Just be aware that the pie explosion setting has a bug and will reset to zero if you come back to the dialog box later.
So there you have it, a simple yet effective way to manage too many pie slices in your charts. As always, thank you for tuning in to the MrExcel netcast. We hope this tip will help you create more visually appealing and informative charts. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time!
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) Issues with Pie Charts
(00:15) Real life examples
(00:27) Choosing Pie of Pie or Bar of Pie
(00:39) Customizing the Chart
(01:31) Deciding on the data to display
(01:41) Adjusting Pie Explosion, Gap Width, and Secondary Plot Size
(02:27) Controlling Gap and Pie Explosion
(03:12) 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:
Bar of Pie chart
Bug in Pie Explosion setting
Excel Charts
Gap Width
Pie Chart types
Pie Explosion
Pie Slices
Secondary Axis
Secondary Plot Size
Small Pie Chart slices
Splitting Pie Chart by value
Together or Separate Pies
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
How to move the small slices from a busy pie chart to their own chart.
Welcome back to another episode of the MrExcel netcast, sponsored by Excel-XL. In this chapter of our Excel Charts series, we will be discussing the common issue of having too many pie slices in our charts. While pie charts may look visually appealing with 3 or 4 slices, in real life, there are often products or categories that are not as significant and can clutter the chart. So, let's dive into how we can effectively manage this problem.
To start off, we have a pie chart with 4 important items and a bunch of smaller, less significant items. We can easily change the chart type by selecting the chart and going to the Chart Design tab, then clicking on Change Chart Type. From here, we have the option to choose from 6 different types of pie charts. In this case, we will select either the Pie of Pie or Bar of Pie chart. These options allow us to move some of the smaller slices to a secondary axis, making the chart more manageable.
Once we have selected the Bar of Pie chart, we can right-click on the chart and choose Format Data Series. This gives us control over how the slices are split between the main and secondary axis. We can choose to split them by position, value, or percentage value. In this example, we will split them by value and set the second plot to contain values less than a certain amount. This allows us to focus on the 4 main items in the pie chart and have a separate bar chart for the smaller items.
But that's not all, we can also adjust the pie explosion, gap width, and secondary plot size to further customize our chart. The pie explosion setting controls how much the smaller slices are separated from the main pie, while the gap width determines the spacing between the pies. We can also choose to have the pies together or separate. Just be aware that the pie explosion setting has a bug and will reset to zero if you come back to the dialog box later.
So there you have it, a simple yet effective way to manage too many pie slices in your charts. As always, thank you for tuning in to the MrExcel netcast. We hope this tip will help you create more visually appealing and informative charts. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time!
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) Issues with Pie Charts
(00:15) Real life examples
(00:27) Choosing Pie of Pie or Bar of Pie
(00:39) Customizing the Chart
(01:31) Deciding on the data to display
(01:41) Adjusting Pie Explosion, Gap Width, and Secondary Plot Size
(02:27) Controlling Gap and Pie Explosion
(03:12) 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:
Bar of Pie chart
Bug in Pie Explosion setting
Excel Charts
Gap Width
Pie Chart types
Pie Explosion
Pie Slices
Secondary Axis
Secondary Plot Size
Small Pie Chart slices
Splitting Pie Chart by value
Together or Separate Pies
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
How to move the small slices from a busy pie chart to their own chart.
14 سال پیش
در تاریخ 1389/04/25 منتشر شده
است.
7,081
بـار بازدید شده