# 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