Show Partial Project Completion in Excel Pie Chart Slices
Question details
Show each project's share of total cost alongside its completion percentage in an Excel chart.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants a pie-like visualization that compares project costs and shows how much of each project is complete.
- Observed behavior
- A standard pie chart cannot proportionally fill each slice using a separate completion value.
Arrange your data with a project name, total cost, and completion percentage for each project. Enter completion values as percentages between 0% and 100%, and confirm that project costs are nonnegative.
Use an Excel sunburst chart to show cost and completion
Use a sunburst chart when you want a circular visualization with project costs on the inner ring and completed and remaining portions on the outer ring.
Excel's standard pie chart does not support a separate proportional fill within each slice. A sunburst chart instead displays completion as a second level of the cost hierarchy.
In your worksheet, calculate the completed amount as total cost multiplied by completion percentage, and the remaining amount as total cost multiplied by one minus the completion percentage.
Create three adjacent columns named Project, Status, and Amount. Add two rows per project: one with the status Completed and its calculated amount, and one with Remaining and its calculated amount.
Select the chart table, including its headers, then choose Insert > Insert Hierarchy Chart > Sunburst.
Select individual outer-ring segments and use Format Data Point > Fill to give completed portions one color and remaining portions another. Add labels from Chart Design > Add Chart Element > Data Labels if needed.

Compare completed and remaining costs with a stacked bar chart
Use a stacked bar chart when you want a clearer comparison of total costs and completion across projects.
Show Project Completion with a Stacked Bar in WPS Spreadsheet
Use WPS Spreadsheet to calculate completed and remaining costs and display them as a stacked bar chart for each project.
- 1. Open your workbook: Open WPS Spreadsheet and choose Open to select your Excel workbook.
- 2. Calculate the portions: Add Completed and Remaining columns. For a total cost in B2 and a completion percentage in C2, enter =B2*C2 and =B2*(1-C2), then fill the formulas down.
- 3. Create a chart table: Place the project names, completed amounts, and remaining amounts in adjacent columns, then select the table and its headers.
- 4. Insert a stacked bar: Choose Insert > Chart, select a stacked bar chart, and use the chart formatting options to distinguish the two series.

Frequently Asked Questions
Can Excel fill part of each pie slice using a completion percentage?
Not directly in a standard pie chart. Calculate completed and remaining amounts and use Insert > Insert Hierarchy Chart > Sunburst, or use a stacked bar chart instead.
How do I calculate the completed and remaining costs?
If total cost is in B2 and completion percentage is in C2, enter =B2*C2 for the completed amount and =B2*(1-C2) for the remaining amount. Fill both formulas down for the other projects.
Why should I use a stacked bar instead of a 100% stacked bar?
A regular stacked bar preserves the difference in total cost between projects. A 100% stacked bar makes every bar the same length, emphasizing proportions rather than cost totals.
What if I can't find the sunburst chart option?
Sunburst charts are available in Excel 2016 and later desktop versions. If your version does not offer Insert > Insert Hierarchy Chart > Sunburst, use a stacked bar chart to show completed and remaining amounts.




