Suppose we change the number for Values in second plot to 2: This will bring up a panel called Format Data Series. To group together a different number of slices, simply double click any element in the bar chart. 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.

How to make a pie chart in excel mobile