Thanks for your comment. There is an upgraded version of this video where we have depicted the process of making an interactive gantt chart in Excel. please watch and comment.
Sir.very good information for planning engineer.Formula is not looking while viewing video in mobile. Kindly zoom so that it can be visible through small screen.
Sir, One more question If one or some activities take more or less time than scheduled time incorporated in that chart, how it will be projected over the same sheet. Kindly provide a video. Regards
Very fine but if the entire building project duration is five years and more than one means two/three/ four etc. Towers of multi storied are there in a building project, how to make a Bar Chart of the entire project, please provide in the next video. Regards
Please select all the cells, go to home and go to format cells. Click on protection, check the locked option. Now close the popup and go to Review and click on protect sheet option, if required put a password and click OK. Hope this helps.
Sorry couldn't understand the issue. All the schedule and templates used in this channel are solely prepared by us at ProjectoMetric. Please mention any specific issue over the same.
Excellent work tech from srilanka. Living Qatar
Glad you liked it!
Thank u so much it helped me alot
Great job, explanation so good that I didn't need to speak your language to understand!!! Genius!
Thanks a lot for your compliment. Love from India.
Thank you.. very simply explained
Thanks a lot for your compliment.
Wonderful explanation, Appreciate it
Glad it was helpful! Please suggest any further video topics for this channel.
Great! Many thanks.
Thank you for your compliment. Stay with us for more on construction.
khoob bhalo...onek dhonvaad
Thanks for the compliment
Wonderful video,, must watch
Thanks a lot for your compliments.
Hi..is possible to contact with you on Priv, regarding some subject of the formuls?
I try used this one: =JEŻELI(ORAZ($E12=I$4),1,"") but not work
Thank you very much sir
Most welcome
Thank you sir 🙏
Welcome, stay tuned
Sir if any activity happens again ..then can I show chart against in the same row
Good one.
Thanks for the compliment.
VERY GOOD AND THANKS
Thanks for your comment. There is an upgraded version of this video where we have depicted the process of making an interactive gantt chart in Excel. please watch and comment.
Sir.very good information for planning engineer.Formula is not looking while viewing video in mobile. Kindly zoom so that it can be visible through small screen.
Please try the following: go to settings and change the resolution to 720P
Thank you
You're welcome. You may suggest any further topic for videos in this channel.
Sir,
One more question
If one or some activities take more or less time than scheduled time incorporated in that chart, how it will be projected over the same sheet.
Kindly provide a video.
Regards
Super easy way 🎉
Thanks for your compliment.
Thanks buddy ❤
Welcome. Stay with us for more useful videos on project management.
Hi can u teach me how to highlight a range of cells of 30 mins interval when I key in a cell with data like 0700-1100. As in 7am to 11am
THANK YOU KAKU
Welcome
Thanks for it bro...
Welcome. Stay with us for more useful videos on project management.
Best video
Thank you very much for your compliment.
Link for download this sheet please... Thank you
Nice video sir
But kuch doudt h please guide me
Please tell the issue
Very fine but if the entire building project duration is five years and more than one means two/three/ four etc. Towers of multi storied are there in a building project, how to make a Bar Chart of the entire project, please provide in the next video.
Regards
for big buildings software like primavera or ms project can be checked
Good
Thanks for your compliment
Which formula you used for that DAYS column?
This is a simple if logic, mentioned in the cell. If you need i can mail you 1 to 1
Please upload Excel sheet format
If we pause activity for a few days, how will we miss that slot in graph bar
Since the duration is from thr start date to finish date, you will continue to see the bar during the paused period also.
Thank u
Welcome. Stay tuned.
Very nice & informative video. Thanks for sharing. Can we have different colors for different activities bar?
Bhai Direct condition formatting use kr ke new formula bna k and wala formula bna te to dircet aa ja ta formeting.
Yes, thanks for the idea.
❤❤❤❤
How to get that lock symbol
You can lock a cell from review tab
Just press F4
=IF(AND($D3=F$2),1,"")
sir this formula is true or not because its not working
You can send your sheet to brainquisitive@gmail.com, I will check it and return
Sir, this formula is not working for me as well
@@mendangjamir7921 Please send me your excel sheet to brainquisitive@gmail.com , i will make it work.
@@mendangjamir7921 Please send me the excel sheet to brainquisitive@gmail.com, i will make it work
Formula lagane pr blank cell ho rha h 1 nhi aa rha h , pls help
What is the formula you are writing? Please mention
Drk nhi ho rha kuch problam hoga
Please go to settings in your video and change the Quality to 720p.
Formula lagane pr blank cell ho rha h 1 nhi aa rha h , pls help
Pls send me your excel sheet will see. brainquisitive@gmail.com
When I drag this formula the formula was changed it's row and cell
Put dollar sign $ before the row and column numbers in the formula, It will not drag. You may watch the formula part in the video very closely.
Watched it but not helping
What's the problem? Pls specify so that we can help.
How to lock formula??
Please select all the cells, go to home and go to format cells. Click on protection, check the locked option. Now close the popup and go to Review and click on protect sheet option, if required put a password and click OK. Hope this helps.
This data your copy, paste to other channel i know because I see 👀
Sorry couldn't understand the issue. All the schedule and templates used in this channel are solely prepared by us at ProjectoMetric. Please mention any specific issue over the same.
Please clear if statement so that every one can learn easily.
Please write the formula here
Please understand the logic. If not readable, please increase the video quality to 720P
WHY THE FIRST FORMULA DIDNT WORK?
Please mention at what point of time ?
दिखाई nhi de rha hai। पिक्चर साफ nhi hai
Please go to settings and change the quality to 720p or 1080p
Formula is not visible.।। Can you please type formula here
Request you to increase the video quality to at least 720P
Formula nahi dikh raha
Please change resolution to at least 720P to view it correctly
Your formula not working
Not possible. You can send your file to brainquisitive@gmail.com so that i can check it and correct.