Google Sheets: Create Timeline (Gantt Charts) (new feature in some Workspace Accounts only!)

Channel Avatar
Comment
X
Share
Google Sheets: Create Timeline (Gantt Charts) (new feature in some Workspace Accounts only!)
Google Sheets: Create Timeline (Gantt Charts) (new feature in some Workspace Accounts only!)
You can now create timelines/Gantt charts with a few clicks in Google Sheets. For best results, first set up your data, and then create your timeline:

Make a copy of this demo Google Sheet to follow along: https://doittraining.page.link/timelinedemo

0:00 Intro
0:16 Required fields for Timeline
0:48 Set up Dates
1:29 Set up Duration
2:16 Create drop-down menus for repeated values (data validation)
3:30 Create Timeline
3:50 Adjust Timeline
4:50 End date vs. Duration
4:31 Optional settings (card details, grouping, color)
5:49 Color cards by conditional formatting
7:24 View options
7:49 View card details and Edit data

Timelines are available only in some Workspace Accounts – see more here: https://support.google.com/docs/answer/12935277?hlen#zippy%2Cthese-workspace-editions-can-use-timeline-view

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *