Quick Jump
ToggleExcel Half Pie Chart Template – Free Download
A half pie chart (also known as a semicircle or half-moon chart) is a 180-degree version of a basic pie graph that illustrates the relative sizes of data. This brief guide will teach you how to quickly create this half pie chart in Excel:
![How to create a pie chart in Excel](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/how-to-create-a-half-pie-chart-in-excel.png)
Sample Data
Consider this simple table containing the sales of a fictitious clothing store sorted by category:
![Pie chart data table](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/pie-chart-data-table.png)
Now, let’s get down to business.
Step 1. Add a Dummy Data Series
The whole trick here is to create a dummy data series that will take up half of a full pie chart and make that slice invisible to get exactly what we’re looking for.
To do that, start with setting up a dummy data series that contains the sum of all of the actual values in your data table by using the SUM formula.
- Type “Total” into A7.
- Enter “=SUM(B2:B6)” into B2.
![Use the SUM function](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/use-the-sum-function.png)
Step 2. Create a Simple Pie Chart
The chart data is ready to go, meaning it’s time to build a regular pie chart.
- Highlight the expanded data table (A1:B7).
- Go to the Insert tab.
- Click “Insert Pie or Doughnut Chart.”
- Hit the “Pie” button.
![Create a regular pie chart](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/create-a-regular-pie-chart.png)
Here’s what you should end up with by the end of this step.
![Simple Excel pie chart](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/simple-excel-pie-chart.png)
Step 3. Hide the Dummy Series
Your next step is to make the dummy series invisible, effectively getting a half pie chart.
- Double-click on Series “Total” represented by the largest slice of the pie chart.
- Click the “Fill” button.
- Pick white from the color palette.
![Hide the dummy series](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/hide-the-dummy-series.png)
Here’s the result:
![Half pie chart in excel free template](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/half-pie-chart-excel.png)
Step 4. Rotate the Half Pie Chart
Technically, you’re good to go, but if you want to rotate the half-moon chart to make it a bit more accessible, here’s how you do that.
Right-click on your half pie chart and select “Format Data Series” from the menu that pops up.
![Format Data Series in Excel](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/format-data-series-in-excel.png)
- Switch to the Series Options tab.
- Change “Angle of first slice” to “270°” or “90°.”
![Rotate the half pie chart](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/rotate-the-half-pie-chart.png)
Step 5. Clean up the Chart Legend
Finally, remove the legend label related to the hidden slice of the pie chart. To do that, right-click on the label that reads “Total” and click “Delete” to erase it.
![Remove the legend item linked to the dummy series](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/remove-the-legend-item-linked-to-the-dummy-series.png)
Check out the final result – once you have finished the last step, your semicircle chart is ready to go.
![How to create a pie chart in Excel](https://spreadsheetdaddy.com/wp-content/uploads/2021/07/how-to-create-a-half-pie-chart-in-excel.png)