Nov 03 2023 11:43 AM
Hello, I'm new to making Gantt charts so apologies if this is a straightforward question!
I have my Gantt chart in Excel made from a stacked bar chart, but wondering how I can format it so that consecutive tasks for the same project appear in the same row? e.g. a task ends on 7 Jan, the next one starts on 8 Jan and is the next phase of the project so I'd like them to appear side-by-side.
Many thanks
Nov 04 2023 07:33 AM
Creating a Gantt chart in Excel where consecutive tasks for the same project appear in the same row can be achieved using a stacked bar chart, but it requires some data formatting and settings adjustments. Here's how you can do it:
Project | Task | Start Date | Duration |
Project A | Task 1 | 01-Jan | 5 |
Project A | Task 2 | 06-Jan | 3 |
Project B | Task 3 | 01-Jan | 4 |
Project B | Task 4 | 05-Jan | 2 |
By following these steps, you can create a Gantt chart in Excel where consecutive tasks for the same project appear side-by-side in the same row, allowing for clear project visualization. The text were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.