Hi All,
I have a list of projects. Each project has a set of tasks and a start date associated with the tasks that go one after the other. I am looking to create a bar chart with this data.
- Vertical Y axis would be project name.
- Each bar (for a project) depicts the color-coded project tasks one after the other, as per the start dates in the data table. Each task has its own color, and is maintained in the bar for all projects.
- Horizontal X axis depicts timeline depending on the dates provided in the data table.
- Legend shows the color-codes for each task type
I have tried to mimic this output by putting it in Excel cells in the attachment, so as to provide an idea of how the final output should look like.
Would appreciate if you could provide the steps to create this chart. I was unable to do this using the automated Excel chart options - it just splits out the tasks separately. Thanks in advance.
Bookmarks