Having Overlapping Time line in Stack Bar Chart.

[jp16]

Hi, i have two data set, one is Estimate Start and End Date, one is Actual Start and End Date.
I wanted to make Both appear in one Bar Chart, with 50% transparent so that user can have a better visual understanding.
So far, i have only manage to do the Estimate Start and End Date, i tried to put in the Actual Start and End date, but somehow, cant.

Would appreciate if anyone can help.

See my attachment for example.

[Pichai_Tee]

You start the right way, but the hard part is following.
Let calculate the Actual data the same way as Estimation.
Add Actual data into the chart, then change them to Secondary.
Delete Secondary Horizontal Axis.
Add Secondary Vertical Axis, set Reverse Order, then set Label Position to None.
Finally set format as you want.

See result in the attachment.

[jp16]

Hi, thanks very much.

But how do we Add Secondary Vertical Axis?