Chart & Visualization Issues

Show Partial Project Completion in Excel Pie Chart Slices

Tauseeq MagsiTauseeq Magsi Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Calculate cost portions

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.

2
Create a chart table

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.

3
Insert the sunburst

Select the chart table, including its headers, then choose Insert > Insert Hierarchy Chart > Sunburst.

4
Format the segments

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.

Use an Excel sunburst chart to show cost and completion
What the rings represent: The inner ring shows each project's share of total cost. The outer ring divides that project's cost into completed and remaining amounts; it does not fill the original pie slice.
Visualize project progress

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. 1. Open your workbook: Open WPS Spreadsheet and choose Open to select your Excel workbook.
  2. 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. 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. 4. Insert a stacked bar: Choose Insert > Chart, select a stacked bar chart, and use the chart formatting options to distinguish the two series.
Compare completed and remaining project costs in one chart.Open and edit Microsoft Excel XLSX and XLS files.Create and format charts in a familiar spreadsheet interface.Use WPS Office for free.
microsoft office alternative - wps office

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.