Forum Discussion
How to create Gantt Chart using quarterly start and end dates and no duration
Hello. I am trying to create a Gantt chart using quarterly data. I have the Start and End quarters but did not caluclate the duration. How would I go about creating a visual gantt chart by quarters instead of actual dates without a caluclated duration? For example, if a work product starts in Q1 2022 and ends in Q2 2022, it will be a shorter bar than a different work product that starts in Q1 2022 and ends in Q4 2022.
P.S. Once this questioned is answered, I'd like to know where I can drop the "Area" Column so I can organize each work product into its respective category. Thanks in advance!
Sample Data:
https://docs.google.com/spreadsheets/d/1tAHcSJLJw_H20zQ_2OM4CTKSxyElCwaE/edit#gid=916897055
1 Reply
- v-luwang-msft
Community Support
Hi brittneyjacks ,
When I click the link you shared ,it tells me:
"You need access rights
Request access or change to an account with access rights."Please adjust the permissions for sharing files.
Best Regards
Lucien