How to create a half pie chart in Excel?
Sometimes, if you have a data range with total data, when you insert a pie chart to show these data, one half of pie is the series “total”, another half is the other point values as shown as below. And sometimes, you may want to create a half pie and excluding the series “total”, now I will tell you how to solve it in Excel.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
For example, you have a range of data as shown as below, and now creating a half pie excluding total.
1. Select all the data range and click Insert > Pie > Pie. See screenshot:
2. Click at the Legend Entry of Total, and then click it again to select it, then remove the Legend Entry of Total, see screenshots:
3. Click at the “Total” half pie, then click it again to select this half pie. Then right click to show the Mini toolbar. See screenshot:
4. Click the arrow of the Shape Fill, and select No Fill in the list. See screenshot:
5. Click the arrow of the Shape Outline, and select No Fill in the list. See screenshot:
Note: In Excel 2007, you can hide the half pie of Series “Total” with following steps:
(1) Right click the half pie, and select Format Data Point from the context menu;
(2) In the coming Format Data Point dialog box, click the Fill in left bar, and check the No Fill;
(3) Click the Border Color in the left bar, and check the No line;
(4) Click the Close button.
Then the whole pie become a half pie. Now you can rotate it if you need.
Right click at the pie and select Format Data Series, then specify the angel you need in the popped out dialog. See screenshot:
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 3 years agoPerfect solution for me! I was thinking that I would have to do this manually - a graphic nightmare!