How to How to Create Half Pie Charts in Excel
Learn to create half pie charts (semi-circular pie charts) in Excel to display data in a visually compact format. Half pie charts are ideal for dashboards and reports where space is limited, showing proportional data while maintaining professional aesthetics. This tutorial covers creating the chart, customizing appearance, and formatting for maximum impact.
Why This Matters
Half pie charts save space while effectively communicating proportional data, making them essential for professional dashboards and reports. They offer better visual clarity than traditional pie charts when displaying limited categories.
Prerequisites
- •Basic Excel knowledge and data entry skills
- •Data organized in cells (labels and values)
- •Understanding of chart types and basic formatting
Step-by-Step Instructions
Prepare your data
Organize your data in two columns: one with category labels and one with corresponding values. Ensure all values are positive numbers and data is clean (no blanks or errors).
Insert a pie chart
Select your data range including labels and values, then go to Insert > Charts > Pie Chart > 2-D Pie, and select the standard pie chart option.
Adjust the angle of the first slice
Right-click the pie chart > Format Data Series > Series Options > Angle of first slice. Set this to 270° to rotate the chart to display as a half circle (semi-circle appearance).
Remove half of the slices visually
Right-click the pie chart > Format Data Series > Series Options > Doughnut hole size slider to create a half-donut effect, or delete unwanted data points to show only the top half.
Customize and format
Add chart title via Chart Design > Add Chart Element > Chart Title, adjust colors via Format Data Series, and resize the chart to display the half-circle clearly.
Alternative Methods
Using Doughnut Chart as base
Start with a Doughnut chart instead of a pie chart, set Angle of first slice to 270°, then increase the doughnut hole size to create a half-ring visual effect.
Combining two pie charts
Create two overlapping pie charts—one visible on top and one hidden—to simulate a half pie effect with more control over appearance.
Tips & Tricks
- ✓Use contrasting colors for each slice to improve readability and visual distinction.
- ✓Keep labels and data series names concise to avoid clutter in the half pie chart.
- ✓Test different sizes of the chart to ensure the half-circle format displays clearly on your dashboard.
Pro Tips
- ★Set Angle of first slice to 270° for a perfect bottom-half display; use 90° for top-half orientation.
- ★Combine data labels with percentages (Chart Design > Add Chart Element > Data Labels) for professional reporting.
- ★Use conditional formatting on source data to highlight the highest or lowest values represented in your half pie chart.
Troubleshooting
Right-click the pie chart, select Format Data Series, go to Series Options, and verify Angle of first slice is set to 270°. If it's different, change it to 270° to display the half-circle correctly.
Go to Chart Design > Add Chart Element > Data Labels > More Data Label Options, and adjust label position to Outside End or Inside End. Increase font size if needed.
Right-click each slice individually, select Format Data Point, and choose a color from Format Data Point > Fill & Line. Repeat for each slice to customize colors.
Click the chart, go to Chart Design > Change Chart Type, verify the chart type is still 2-D Pie, then manually resize by dragging corners while holding Shift to maintain proportions.
Related Excel Formulas
Frequently Asked Questions
Can I create a half pie chart in older versions of Excel?
What's the difference between a half pie chart and a doughnut chart?
How do I add percentages to my half pie chart?
Can I animate a half pie chart in Excel?
This was one task. ElyxAI handles hundreds.
Sign up