Forum Discussion

brittneyjacks's avatar
brittneyjacks
Regular Visitor
4 years ago

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's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity 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