How to create Gantt Chart using quarterly start and end dates and no duration

[brittneyjacks]

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

[v-luwang-msft]

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