A Half Pie Chart is a 180 degrees graph that represents a composition as a whole. In Microsoft Excel, you can create a half chart if your data range has a total. When a total is in your data range, half the pie chart will be total, and the other parts will contain the other data series.
How to create a Half Pie Chart in Excel
Follow the steps below to create a Half Pie Chart in Microsoft Excel:
- Launch Excel.
- Enter some data on your spreadsheet or use existing data.
- Highlight the data range.
- Click the Insert tab.
- Click the Pie Chart button in the Charts group and select a Pie Chart from the menu.
- The Pie Chart appears on the spreadsheet.
- Click the Legend Entry of the total and try to click it again to select it.
- Delete total.
- Click the total category on the Pie Chart and click it again to select it.
- Right-click the total category and click Fill.
- Select No Fill
- Then click Outline and select No Outline
- Now, we are going to specify the angle we need.
- Right-click the chart and select Format Data Series from the context menu.
- A Format Data Series pane will appear on the right.
- Under Series options, set the angle of first slice to 270 degrees.
- Now, we have a half Pie Chart.
Launch Excel.
Enter some data on your spreadsheet or use existing data.
Highlight the data range.
Click the Insert tab.
Click the Pie Chart button in the Charts group and select a Pie Chart from the menu.
The Pie Chart appears on the spreadsheet.
Click the Legend Entry of the total and try to click it again to select it.
Delete total.
Click the total category on the Pie Chart and click it again to select it.
Right-click the total category and click Fill.
Select No Fill.
Then click Outline and select No Outline.
Now, we are going to specify the angle we need.
Right-click the chart and select Format Data Series from the context menu.
A Format Data Series pane will appear on the right.
Under Series options, set the angle of the first slice to 270 degrees.
Now, we have a half Pie Chart.
Read next: How to use Slicers in Microsoft Excel to efficiently filter data.
What is the difference between Pie chart and Doughnut chart?
A Pie Chart is a circular graph that displays categories as slices that each represent a proportion of the whole, while the donut chart is a variant of the pie chart, with the area of the center cut out; it displays categories as arcs rather than slices.
What is half a Pie chart called?
A half pie chart is also known as a half-moon or semi-circle chart due to its shape. The half pie chart has a unique look and shows the most important categories in your pie chart, excluding the total.
We hope this tutorial helps you understand how to create a half pie chart in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.
