how do i add the progress bar to the gant chart?

%3CLINGO-SUB%20id%3D%22lingo-sub-3110803%22%20slang%3D%22en-US%22%3Ehow%20do%20i%20add%20the%20progress%20bar%20to%20the%20gant%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3110803%22%20slang%3D%22en-US%22%3E%3CP%3Eive%20copied%20a%20gant%20chart%20over%20to%20a%20new%20spreadsheet%20but%20the%20formulas%20haven't%20crossed%20over%20and%20the%20progress%20bars%20on%20the%20gant%20chart%20do%20not%20come%20up%20when%20i%20enter%20the%20date.%20does%20anyone%20know%20how%20i%20can%20copy%20a%20sheet%20with%20the%20formulas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3110803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3110925%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20i%20add%20the%20progress%20bar%20to%20the%20gant%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3110925%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296042%22%20target%3D%22_blank%22%3E%40Marie1745%3C%2FA%3E%26nbsp%3BCan't%20really%20test%20this%20but%20perhaps%20you%20can%20take%20the%20original%20file%20with%20the%20correctly%20working%20chart%20as%20a%20basis%2C%20save%20it%20with%20a%20different%20name%20and%20copy%20new%20project%20data%20into%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3111077%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20i%20add%20the%20progress%20bar%20to%20the%20gant%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111077%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20response%2C%20unfortunately%2C%20i%20tried%20that%2C%20and%20didn't%20work...%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20any%20formulas%20i%20could%20use%3F%20I'm%20absolutely%20useless%20at%20that%2C%20was%20hoping%20the%20copy%20and%20paste%20would%20of%20done%20that%20for%20me%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

ive copied a gant chart over to a new spreadsheet but the formulas haven't crossed over and the progress bars on the gant chart do not come up when i enter the date. does anyone know how i can copy a sheet with the formulas?

6 Replies

@Marie1745 Can't really test this but perhaps you can take the original file with the correctly working chart as a basis, save it with a different name and copy new project data into it.

 

Thanks for the response, unfortunately, i tried that, and didn't work...@Riny_van_Eekelen 

 

is there any formulas i could use? I'm absolutely useless at that, was hoping the copy and paste would of done that for me

@Marie1745 Can't tell if I don't see the file(s) you are working with.

@Riny_van_Eekelen 

 

cant see where i can attach it ?

@Marie1745 You can in a Direct Message.

@Marie1745 Try sending me a direct message.