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

[@abicchannel8890]

Excellent work tech from srilanka. Living Qatar

[@projectometric]

Glad you liked it!

[@mayankbawa4000]

Thank u so much it helped me alot

[@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.

[@amitkolambkar]

Thank you.. very simply explained

[@projectometric]

Thanks a lot for your compliment.

[@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.

[@PrabhakarJi]

khoob bhalo...onek dhonvaad

[@projectometric]

Thanks for the compliment

[@10787anuj]

Wonderful video,, must watch

[@projectometric]

Thanks a lot for your compliments.

[@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

[@civilengineeringpower]

Thank you very much sir

[@projectometric]

Most welcome

[@rkmoviepoint1594]

Thank you sir 🙏

[@projectometric]

Welcome, stay tuned

[@PixBlend78]

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

[@jaikishansmspl39]

Good one.

[@projectometric]

Thanks for the compliment.

[@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.

[@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

[@Gopalsingh-im7jj]

Thank you

[@projectometric]

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

[@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

[@gajananeh8469]

Super easy way 🎉

[@projectometric]

Thanks for your compliment.

[@kshitijkumar3532]

Thanks buddy ❤

[@projectometric]

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

[@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

[@arijitbiswas7827]

THANK YOU KAKU

[@projectometric]

Welcome

[@peshawarhouses1283]

Thanks for it bro...

[@projectometric]

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

[@vaibhavprabhu3885]

Best video

[@projectometric]

Thank you very much for your compliment.

[@peshawarhouses1283]

Link for download this sheet please... Thank you

[@mohd.ibrahim737]

Nice video sir
But kuch doudt h please guide me

[@projectometric]

Please tell the issue

[@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

[@beingethicalwithlogics3113]

Good

[@projectometric]

Thanks for your compliment

[@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

[@diyaharihar6024]

Please upload Excel sheet format

[@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.

[@rsingh250]

Thank u

[@projectometric]

Welcome. Stay tuned.

[@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.

[@takalutask3404]

❤❤❤❤

[@sampapang6724]

How to get that lock symbol

[@projectometric]

You can lock a cell from review tab

[@abullais0450]

Just press F4

[@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

[@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]

[@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.

[@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.

[@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.

[@neerajkumarjoshi4762]

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

[@thecivileers6122]

Please write the formula here

[@projectometric]

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

[@abdelmalek9682]

WHY THE FIRST FORMULA DIDNT WORK?

[@projectometric]

Please mention at what point of time ?

[@anil7271]

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

[@projectometric]

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

[@bishwajeetsingh4211]

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

[@projectometric]

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

[@siddique6419]

Formula nahi dikh raha

[@projectometric]

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

[@akankshas7650]

Your formula not working

[@projectometric]

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