Get instant live expert help on I need help with excel progress bar

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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