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

%3CLINGO-SUB%20id%3D%22lingo-sub-2281378%22%20slang%3D%22en-US%22%3EHow%20to%20set%20a%20checklist%20with%20a%20project%20timeline%20on%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281378%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20several%20to-do's%20that%20I%20put%20on%20Excel%20as%20a%20list.%20On%20another%20sheet%20I%20would%20like%20to%20create%20a%20project%20timeline%20and%20configure%20that%20let's%20say%20first%2010%20tasks%20i%20will%20be%20done%20with%20by%2001.05.2021%20and%20so%20on.%3C%2FP%3E%3CP%3EWhat%20I%20also%20want%20is%20to%20add%20next%20to%20each%20to-do%20a%20tick-box.%20So%20when%20I%20am%20done%20with%20it%20I%20want%20to%20be%20able%20to%20click%20on%20it%20and%20tick%20it%20and%20therefore%20mark%20it%20as%20done.%20Simultaneously%20I%20want%20to%20see%20this%20on%20my%20project%20time-line%20when%20I'm%20done%20with%20the%20previously%20mentioned%2010%20tasks%20let's%20say%20that%20the%20timeline%20turns%20partially%20green%20up%20to%2001.05.2021%20meaning%20I%20succeeded%20this%20part.%3C%2FP%3E%3CP%3EIs%20something%20like%20this%20possible%20with%20Excel%3F%20Unfortunately%20I%20can't%20use%20MS%20Project%20to%20do%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281378%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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