This chart is an example of a 100% stacked column chart.

The data used to plot the chart looks like this:

How to create this chart

Data used to plot project goal attainment

Data used to plot project goal attainment

Data used to plot project goal attainment

Data used to plot project goal attainment

Data used to plot project goal attainment

Insert > column chart via ribbon

Select 100% stacked column option under 2d bar charts

Chart as inserted

Move legend to top

Reorder series to plot missed data first

Set series overlap and gap width

Set tick marks on vertical axis

Chart in progress

Right-click and set fill color for each series

Final 100% stacked column chart