How to set a checklist with a project timeline on Excel?

Copper Contributor

Hello everyone,

 

I have several to-do's that I put on Excel as a list. On another sheet I would like to create a project timeline and configure that let's say first 10 tasks i will be done with by 01.05.2021 and so on.

What I also want is to add next to each to-do a tick-box. So when I am done with it I want to be able to click on it and tick it and therefore mark it as done. Simultaneously I want to see this on my project time-line when I'm done with the previously mentioned 10 tasks let's say that the timeline turns partially green up to 01.05.2021 meaning I succeeded this part.

Is something like this possible with Excel? Unfortunately I can't use MS Project to do it.

 

Thank you very much in advance

0 Replies