% Percent % Bar Status?

Hi,

I created a horizontal bar chart that shows an estimated duration of given tasks. I would like a % bar status (based on column U of my attached example) on top of it & if possible, thinner than the planned tasks bars.

I attached an example for reference or assistance.

Thanks again....

First you need to calculate the actual duration.
The you need 2 series on both primary and secondary axis.

So add the Start Date again as a series and use newly calculated duration for the 4th series.
Add secondary Vertical axis so you can reverse the scale.
Format secondary horizontal axis scales to match primary.

increase gap width of bars.

Hi Andy Pope,

Great solution for originally asked question!!! Thanks for the feedback.