Mastering Gantt Charts in Google Sheets to Visualize Project Timelines

Подписаться 2,3 тыс.

Просмотров 2,1 тыс.

50% 1

A Gantt chart is a way of visualizing project timelines. In this video, I show you how to create a simple gantt chart for your project in less than 5 minutes. In the rest of the video, I walk you through making it look really professional.
If you want to make a copy of the final Google Sheet from this project, you can do so at the following link: bit.ly/3QN2UaU
Here's the link to my tutorial on conditional formatting for more on that: • Conditionally Format R...

Опубликовано:

16 ноя 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 3

@Drag0nStorm1 2 месяца назад

how... how are you pushing the month cells when you change the value? What I mean is Let's say feb has 28 days and you have 28 columns between the FEB and MAR columns when you change the value in the FEB cell from 2/1/23 to 3/1/23 it changes to MAR, sure, BUT WHAT IS ADDING COLUMNS TO COMPENSATE FOR THE ADDED DATES IN BETWEEN? in my experience, the merged cell and the colour and formatting of it, would all generally stay in the same cell REFERENCE, and so the date of the new MARCH 29th would pop into the MAR cell wouldn't it?? breaking everything? Is the key in collapsible grouping?

@Drag0nStorm1 2 месяца назад

oh NVM i missed that you left blank columns so all are equally 31 days long hmhmmhmmm sorry i spoke too soon xD

@SheetsNinja 2 месяца назад

Yeah, you can either leave extra blank columns if you want to be able to have any month fit into any slot, otherwise for some people they prefer to keep it tied to a calendar year in which case February would need 29 days for leap year but otherwise you could remove the extra day columns.