“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hello. I want to represent a percentage figure as a progress bar in a individual cell (i.e, 50% will mean the cells shows a bar half full in the cell, or 25% will show a bar a quarter full in a cell). Please can someone advise how to do this. I want to track progress of various activities, so will constantly be changing the % figure in the cell and want a visual representation (i.e a bar showing how much progress has been made) Thanks

Solved by I. L. in 22 mins

need help with a gant chart, it was a template that i downloaded which works for programming. it uses conditional formating for the progress bars etc. i need to know is there a way using a formula that in the bars it would show the number of men required in the progress bar?

Solved by E. E. in 27 mins

How do we get to save a spreadsheet without having a pop up dialogue box saying "Save As..........................." showing a progress bar? It also lags or takes a long time to save. This problem persists when saving to a network share folder.

Solved by I. D. in 21 mins

=SUMPRODUCT(--(('N:\00. Data Operations Progress\P18\[Data Ops Progress - TV P1801-P1810.xlsx]NZTV (TV1-4,Prime,MAORI)-Promo'!$A:$A)=P1804), --(('N:\00. Data Operations Progress\P18\[Data Ops Progress - TV P1801-P1810.xlsx]NZTV (TV1-4,Prime,MAORI)-Promo'!$B:$B)= "10 NET-CITY"), --(('(N:\00. Data Operations Progress\P18\[Data Ops Progress - TV P1801-P1810.xlsx]NZTV (TV1-4,Prime,MAORI)-Promo'!$W:$W)>=L$3), --(('N:\00. Data Operations Progress\P18\[Data Ops Progress - TV P1801-P1810.xlsx]NZTV (TV1-4,Prime,MAORI)-Promo'!$W:$W)<=L$4))

Solved by F. A. in 21 mins

IF(and(VLOOKUP(C7,'[Transport Progress Report Aus Schedule AusNZ 2 AM Brisbane time.xlsx]Transport Progress Report_1'!$C$7:$I$1714,7,0)=N7,INDEX('[Transport Progress Report Aus Schedule AusNZ 2 AM Brisbane time.xlsx]Transport Progress Report_1'!$A:$A,MATCH(C7,'[Transport Progress Report Aus Schedule AusNZ 2 AM Brisbane time.xlsx]Transport Progress Report_1'!$C:$C,0))="MOLINE TRUCKING),"TRUE,FALSE) what's wrong with this formula?

Solved by C. E. in 22 mins