7 minutes trick to Bar Chart or Gantt Chart in Excel | Smart Project Management

[@jayantpandit339]

Great tool explained in very simple way. Thank you so much.

[@projectometric]

Thanks for the appreciation!

[@thekamuigarcia]

Great job, explanation so good that I didn't need to speak your language to understand!!! Genius!

[@projectometric]

Thanks a lot for your compliment. Love from India.

[@PrabhakarJi]

khoob bhalo...onek dhonvaad

[@projectometric]

Thanks for the compliment

[@NadirAfridi-nb7ld]

Thank you Sir,, It was really amazing and informative bundle of thanks ❤

[@projectometric]

thank you for the compliment. keep watching.

[@abicchannel8890]

Excellent work tech from srilanka. Living Qatar

[@projectometric]

Glad you liked it!

[@akbarjawed1]

Wonderful explanation, Appreciate it

[@projectometric]

Glad it was helpful! Please suggest any further video topics for this channel.

[@biswajitdebnath6860]

Great! Many thanks.

[@projectometric]

Thank you for your compliment. Stay with us for more on construction.

[@amitkolambkar]

Thank you.. very simply explained

[@projectometric]

Thanks a lot for your compliment.

[@diwakarojha2838]

Great job sir 👍👍👍👍

[@mayankbawa4000]

Thank u so much it helped me alot

[@projectometric]

Glad that it was helpful! Thanks for your comments.

[@10787anuj]

Wonderful video,, must watch

[@projectometric]

Thanks a lot for your compliments.

[@hrishihegde1343]

Thank you 🙏🏻

[@projectometric]

welcome. keep watching.

[@syamaldas8468]

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

[@AbdurRahim-ym4bu]

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.

[@projectometric]

Please try the following: go to settings and change the resolution to 720P

[@rkmoviepoint1594]

Thank you sir 🙏

[@projectometric]

Welcome, stay tuned

[@gajananeh8469]

Super easy way 🎉

[@projectometric]

Thanks for your compliment.

[@kshitijkumar3532]

Thanks buddy ❤

[@projectometric]

Welcome. Stay with us for more useful videos on project management.

[@civilengineeringpower]

Thank you very much sir

[@projectometric]

Most welcome

[@peshawarhouses1283]

Thanks for it bro...

[@projectometric]

Welcome. Stay with us for more useful videos on project management.

[@PixBlend78]

Sir if any activity happens again ..then can I show chart against in the same row

[@sijukksiju]

VERY GOOD AND THANKS

[@projectometric]

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.

[@jaikishansmspl39]

Good one.

[@projectometric]

Thanks for the compliment.

[@lyn5946]

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

[@szymonkuzko5231]

Hi..is possible to contact with you on Priv, regarding some subject of the formuls?

[@szymonkuzko5231]

I try used this one: =JEŻELI(ORAZ($E12=I$4),1,"") but not work

[@projectometric]

Please send me your working file for any issue... email id is [e-mail] you will get a response.

[@syamaldas8468]

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

[@ErAkashkumar1987]

for big buildings software like primavera or ms project can be checked

[@arijitbiswas7827]

THANK YOU KAKU

[@projectometric]

Welcome

[@sachinjha7510]

If we pause activity for a few days, how will we miss that slot in graph bar

[@projectometric]

Since the duration is from thr start date to finish date, you will continue to see the bar during the paused period also.

[@shriyashdivase2470]

Which formula you used for that DAYS column?

[@projectometric]

This is a simple if logic, mentioned in the cell. If you need i can mail you 1 to 1

[@vaibhavprabhu3885]

Best video

[@projectometric]

Thank you very much for your compliment.

[@peshawarhouses1283]

Link for download this sheet please... Thank you

[@Gopalsingh-im7jj]

Thank you

[@projectometric]

You're welcome. You may suggest any further topic for videos in this channel.

[@mohd.ibrahim737]

Nice video sir But kuch doudt h please guide me

[@projectometric]

Please tell the issue

[@diyaharihar6024]

Please upload Excel sheet format

[@CivilEngineeringhub-]

Why this isn't working in my case when i try to apply this the whole table is filling with one but in your case it occurs in proper way like diagonal?

[@sudhirbhalerao602]

Very nice & informative video. Thanks for sharing. Can we have different colors for different activities bar?

[@manishmanchhani7104]

Bhai Direct condition formatting use kr ke new formula bna k and wala formula bna te to dircet aa ja ta formeting.

[@projectometric]

Yes, thanks for the idea.

[@sampapang6724]

How to get that lock symbol

[@projectometric]

You can lock a cell from review tab

[@abullais0450]

Just press F4

[@beingethicalwithlogics3113]

Good

[@projectometric]

Thanks for your compliment

[@venkatesans8698]

Pls share formula

[@kuldeepsingh-if2hx]

When I drag this formula the formula was changed it's row and cell

[@projectometric]

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.

[@gp2708]

Watched it but not helping

[@projectometric]

What's the problem? Pls specify so that we can help.

[@rsingh250]

Thank u

[@projectometric]

Welcome. Stay tuned.

[@akshayvalaskar2559]

How to lock formula??

[@projectometric]

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.

[@sohrabahmad9474]

Formula lagane par 1 nahi aaraha hai kyun

[@ankitrane28]

Formula lagane pr blank cell ho rha h 1 nhi aa rha h , pls help

[@projectometric]

What is the formula you are writing? Please mention

[@anil7271]

Drk nhi ho rha kuch problam hoga

[@projectometric]

Please go to settings in your video and change the Quality to 720p.

[@royalforce7003]

Formula lagane pr blank cell ho rha h 1 nhi aa rha h , pls help

[@projectometric]

Pls send me your excel sheet will see. [e-mail]

[@takalutask3404]

❤❤❤❤

[@VIPINRAJPUT-x9t]

=IF(AND($D3=F$2),1,"") sir this formula is true or not because its not working

[@projectometric]

You can send your sheet to [e-mail], I will check it and return

[@mendangjamir7921]

Sir, this formula is not working for me as well

[@projectometric]

@@mendangjamir7921 Please send me your excel sheet to [e-mail] , i will make it work.

[@projectometric]

@@mendangjamir7921 Please send me the excel sheet to [e-mail], i will make it work

[@neerajkumarjoshi4762]

Please clear if statement so that every one can learn easily.

[@abdelmalek9682]

WHY THE FIRST FORMULA DIDNT WORK?

[@projectometric]

Please mention at what point of time ?

[@thecivileers6122]

Please write the formula here

[@projectometric]

Please understand the logic. If not readable, please increase the video quality to 720P

[@siddique6419]

Formula nahi dikh raha

[@projectometric]

Please change resolution to at least 720P to view it correctly

[@anil7271]

दिखाई nhi de rha hai। पिक्चर साफ nhi hai

[@projectometric]

Please go to settings and change the quality to 720p or 1080p

[@priyankachourasiya9712]

This data your copy, paste to other channel i know because I see 👀

[@projectometric]

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.

[@akankshas7650]

Your formula not working

[@projectometric]

Not possible. You can send your file to [e-mail] so that i can check it and correct.

[@bishwajeetsingh4211]

Formula is not visible.।। Can you please type formula here

[@projectometric]

Request you to increase the video quality to at least 720P