Progress Chart with 3 variables

I'm not sure I understand exactly what you are looking for in your graphical overview. Are you thinking something like a Gantt chart? Some other stacked bar/column chart? Or something else?

Excel's charts have little to no capacity for data analysis. Often the first steps to create a chart are in the spreadsheet computing the quantities that you want to show in the chart. For example, in this case, you say that you want your chart to show % completed. If you want to show % completed in the chart, you will almost certainly have to compute % completed in your spreadsheet. I am not certain how you intend to compute % completed with the different weightages, so I cannot offer a specific suggestion.

If you will arrange your data/calculations correctly in the spreadsheet, the chart will be very easy to create. Often the difficult task is arranging the data. Excel charts tend to work best with data arranged with the desired horizontal/category axis data (SKU-#??) down the left of the chart table, data series across the top of the table, and the desired values (raw or calculated) in the body of the table.

Without know the specifics of your desired chart, it is difficult to give specific recommendations, but that should give you an overview of what to do next.

Preparing two superimposed bar charts would be difficult to build and maintain. I would avoid this approach except as a last resort.

I am still not sure exactly what you want the chart to show. Since I cannot tell how much of the question is about creating a specific chart in Excel, and how much is about creating charts in general, here's how I might create a simple stacked bar chart that shows fraction complete and fraction pending:

1) Make a copy of the SKU list for the chart's data table. Enter =A5 into O5 and copy down.
2) Compute fraction complete in column P. I'm not sure how you would calculate this, so I choose a simple =COUNTIFS(D5:M5,"done")/10 and copy down. Format as % if you would prefer to see these fractions as percentages.
3) Compute fraction pending in column Q. =1-P5 and copy down. Again, you can format as % if you prefer to display these fractions as percentages.
4) Select O5:Q15 -> Insert -> bar chart -> stacked bar.
5) Formatting as desired.

At this point, you should have a simple stacked bar chart that quickly shows what portion is completed and pending for each SKU. Is that even close to what you want? What do you like about this chart? What more do you want this chart to do? Or do you want something completely different?

However, i also wanted to insert the Start & End Window for each SKU. How can i do that?

That suggests more of a Gantt chart to me, so maybe build it as a Gantt chart (which is still a stacked bar chart). Here's a basic tutorial for creating a Gantt chart: https://www.excel-easy.com/examples/gantt-chart.html

I'm still unsure how you intend to include the weightages in the % completion calculation, so I am going to stick with my COUNTIFS(...)/10. Simply substitute your desired % completion calculation where I have COUNTIFS(...)/10. If you are having trouble with the % completion calculation, explain exactly how the weightages figure into % completion.

Here's how I might build a simple Gantt chart that shows how much is completed and how much is pending for each SKU:

1) As before, I need to calculate % completed for each SKU, so I enter =COUNTIFS(D5:M5,"done")/10 into O5 and copy down. Substitute your actual % completed calculation if this is not exactly how you want to compute % completed.
2) I also need a "total duration" calculation, which is =DATEVALUE(C5)-DATEVALUE(B5) entered into P5 and copied down. Note that the DATEVALUE() function will likely choose to return the first of each month for each mmm-yyyy text date. If you want it to return a different date, you will need to adjust these values to reflect the exact date you want each mmm-yyyy date to represent.

With those two quantities calculated, I can now build the data table for the chart.

3) A copy of the SKU numbers. =A5 in Q5 and copied down.
4) A copy of the start date =DATEVALUE(B5) in R5 and copied down (substitute your desired variation if you want something other than the first of the given month).
5) Calculate the completed duration =O5*P5 in S5 and copied down.
6) Calculate the pending duration =P5-S5 in T5 and copied down.
7) Enter some column labels for this table (to help Excel parse the data series). Enter "start date" in R4, "completed duration" in S4, and "pending duration" in T4.

With the data calculated, build and format the chart.

8) Select Q4:T15 -> Insert -> bar chart -> stacked bar chart.
9) format chart as desired (in particular, format the "start date" series so that it is invisible).

You should have a stacked bar Gantt chart with a floating bar that extends from start date to end date that is colored to show how much of each SKU is completed and how much is pending.

Is that closer to what you want? Did you understand the purpose of each step?

As small as it may seem, it was important to delete the text in cell Q1.
Let us know if you have any questions.

See if the attached looks OK.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.