Table of Contents
To create a bar of pie chart in Excel, follow these steps:
1. Select the data you want to include in the chart.
2. Click on the “Insert” tab and select “Bar of Pie” from the Chart group.
3. A default chart will be created. You can customize it by right-clicking on the chart and selecting “Format Chart Area.”
4. To add a title, click on the chart and type in the title in the “Chart Title” box.
5. To change the color of the bars, click on the bars and go to “Format Data Series.”
6. To add labels, right-click on the chart and select “Add Data Labels.”
7. To change the format of the labels, right-click on them and select “Format Data Labels.”
8. Your bar of pie chart is now ready.
Example:
Suppose you want to visualize the sales of different products in a year. You have the following data:
Product Sales
A $500
B $800
C $300
D $400
E $600
To create a bar of pie chart for this data, follow the steps mentioned above. The resulting chart will show a bar chart with each product represented by a different color. The pie chart on top of the bars will show the percentage of sales each product contributed to the total sales. This chart will give you a clear visual representation of the sales of each product and their relative contribution to the total sales.
Create a Bar of Pie Chart in Excel (With Example)
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.
The benefit of this type of chart is that it provides an easier way to visualize the smallest slices of the pie chart.
This tutorial provides a step-by-step example of how to create the following bar of pie chart in Excel:
Step 1: Enter the Data
First, let’s enter the following dataset that shows the total sales made by 10 different employees at a company:
Step 2: Create a Bar of Pie 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:
Excel will automatically insert the following bar of pie chart:
Step 3: Customize the Bar of Pie Chart
By 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.
To group together a different number of slices, simply double click any element in the bar chart.
This will bring up a panel called Format Data Series.
Suppose we change the number for Values in second plot to 2:
The number of values shown in the bar chart will change to 2:
We can also choose to group together all slices in the pie that are less than a certain percentage of the total pie.
For example, we could group together all slices that make up less than 10% of the total pie:
Excel will automatically calculate the number of slices to include in the bar chart:
In this dataset, the total Sales values sum to 116. Thus, 10% of 116 is 11.6
This means that any employee with less than 11.6 sales is automatically included in the bar chart.
Once you’ve decided how many slices to include in the bar chart, click anywhere on the chart to bring up the tiny plus “+” sign in the top right corner and check the box next to Data Labels to add labels to the chart:
The bar of pie chart is now complete.
The following tutorials explain how to create other common visualizations in Excel:
Cite this article
stats writer (2024). How do you create a bar of pie chart in Excel? Can you provide an example?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-you-create-a-bar-of-pie-chart-in-excel-can-you-provide-an-example/
stats writer. "How do you create a bar of pie chart in Excel? Can you provide an example?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-you-create-a-bar-of-pie-chart-in-excel-can-you-provide-an-example/.
stats writer. "How do you create a bar of pie chart in Excel? Can you provide an example?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-you-create-a-bar-of-pie-chart-in-excel-can-you-provide-an-example/.
stats writer (2024) 'How do you create a bar of pie chart in Excel? Can you provide an example?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-you-create-a-bar-of-pie-chart-in-excel-can-you-provide-an-example/.
[1] stats writer, "How do you create a bar of pie chart in Excel? Can you provide an example?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do you create a bar of pie chart in Excel? Can you provide an example?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.