How do I group small slices on a pie chart in Excel?
How do I group small slices on a pie chart in Excel?
Group Smaller Slices in Pie Charts to Improve Readability
Select Your Data Create a Pie of Pie Chart. Just select your data and go to Insert > Chart.
Click on any slice and go to “format series” Click on any slice and hit CTRL+1 or right click and select format option.
Format the Second Pie so that it is Invisible.
Group Smaller Slices in Pie Charts to Improve Readability
- Select Your Data Create a Pie of Pie Chart. Just select your data and go to Insert > Chart.
- Click on any slice and go to “format series” Click on any slice and hit CTRL+1 or right click and select format option.
- Format the Second Pie so that it is Invisible.