show two gantt bars for one task with planned start/finish and actual start/finish

Joachim Mund

Hi all,

I have a project plan with tasks and planned start/finish and actual start/finish

How can I visualize them with two comparing gantt bars? Planned vs. actual?

Andrée Starå

Hi Joachim,

You’ll have to either add them on different rows or use a report.

To show it in a report, you first would need to save the planned information in another sheet. (Baseline)

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Joachim Mund

Happy to help!

They would show in one downwards like below, and we could also use something to show the hierarchy.

1

2

1

2

Andrée Starå

Hi Joachim,

You’ll have to either add them on different rows or use a report.

To show it in a report, you first would need to save the planned information in another sheet. (Baseline)

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Joachim Mund

Hi Andrée, thanks for your answer.

If I save baseline and actual plan in different sheets, how will the report show the two gantt bars side by side?

This should work without sorting the tasks because of the structure of the project plan.

Next question is how to show the structure of the plan by indentation like in the sheet?

Thank you very much

Andrée Starå

@Joachim Mund

Happy to help!

They would show in one downwards like below, and we could also use something to show the hierarchy.

1

2

1

2

Joachim Mund

Hi Andrée,

with the help of unique numbers and saving each month version 0.....x we were successfull, thanks to your help.

Have a good time, Joachim

Andrée Starå

@Joachim Mund

Excellent!

You're more than welcome!