Super User Asked on February 5, 2021
here is the scenario:
Row1 in Excel: Project A: Task A Jan-20; Task B Mar-20; Task C Apr-20 ||
Row2 in Excel: Project B: Task A Feb-20; Task B Mar-20; Task C Apr-20 ||
Row3 in Excel: Project C: Task A Feb-20; Task B Apr-20; Task C May-20
How can I reflect this into chart to generate each project as a series with multiple dates?
I guess you want something like this, but with multiple series for each project (i.e. the projects are the series, not the tasks...).
Have a look at how this guy did it for one project https://www.projectengineer.net/how-to-create-a-gantt-chart-in-excel/ (image source). You might have to consider all the tasks as if one project, but then use color coding to group by project?
Answered by Mobus on February 5, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP