To create a pie of bar chart to visualize this dataset, highlight the cell range A1:B11, then click the Insert tab along the top ribbon, then click the Pie icon and then click Bar of Pie:Įxcel will automatically insert the following bar of pie chart:īy default, Excel has chosen to group the four smallest slices in the pie into one slice and then explode that slice into a bar chart. This tutorial provides a step-by-step example of how to create the following bar of pie chart in Excel:įirst, let’s enter the following dataset that shows the total sales made by 10 different employees at a company: The benefit of this type of chart is that it provides an easier way to visualize the smallest slices of the pie chart. A bar of pie chart is a pie chart that combines the smallest slices in the chart into one slice and then explodes that slice into a bar chart.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |