7 minutes trick to Bar Chart or Gantt Chart in Excel

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

Рет қаралды 117,214

3 жыл бұрын

Join this channel to get access to perks:
/ @projectometric
Preparing a bar chart or Gantt chart in excel is very easy with if-and logic and conditional formatting. In this video you will learn to make a professional looking Gantt / bar chart from scratch.
For more videos on construction projects and contract management please subscribe our channel.
#barchartinexcel #exceltips #constructionmanagement
#projectmanagement

Пікірлер: 75

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

@biswajitdebnath6860 8 ай бұрын

Great! Many thanks.

@projectometric 8 ай бұрын

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

@amitkolambkar 11 ай бұрын

Thank you.. very simply explained

@projectometric 11 ай бұрын

Thanks a lot for your compliment.

@10787anuj Жыл бұрын

Wonderful video,, must watch

@projectometric Жыл бұрын

Thanks a lot for your compliments.

@PrabhakarJi 5 ай бұрын

khoob bhalo...onek dhonvaad

@projectometric 5 ай бұрын

Thanks for the compliment

@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

@peshawarhouses1283 Ай бұрын

Thanks for it bro...

@projectometric 29 күн бұрын

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

@rkmoviepoint1594 5 ай бұрын

Thank you sir 🙏

@projectometric 5 ай бұрын

Welcome, stay tuned

@gajananeh8469 29 күн бұрын

Super easy way 🎉

@projectometric 26 күн бұрын

Thanks for your compliment.

@kshitijkumar3532 29 күн бұрын

Thanks buddy ❤

@projectometric 29 күн бұрын

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

@lyn5946 22 сағат бұрын

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

@PixBlend78 5 ай бұрын

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

@sijukksiju 9 ай бұрын

VERY GOOD AND THANKS

@projectometric 9 ай бұрын

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.

@takalutask3404 2 ай бұрын

❤❤❤❤

@sudhirbhalerao602 2 жыл бұрын

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

@rsingh250 Жыл бұрын

Thank u

@projectometric Жыл бұрын

Welcome. Stay tuned.

@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

@beingethicalwithlogics3113 Жыл бұрын

Good

@projectometric Жыл бұрын

Thanks for your compliment

@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 8 ай бұрын

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

@peshawarhouses1283 Ай бұрын

Link for download this sheet please... Thank you

@diyaharihar6024 5 ай бұрын

Please upload Excel sheet format

@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

@sachinjha7510 10 ай бұрын

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

@projectometric 8 ай бұрын

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

@mohd.ibrahim737 Ай бұрын

Nice video sir But kuch doudt h please guide me

@projectometric Ай бұрын

Please tell the issue

@manishmanchhani7104 11 ай бұрын

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

@projectometric 11 ай бұрын

Yes, thanks for the idea.

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

@sampapang6724 7 ай бұрын

How to get that lock symbol

@projectometric 7 ай бұрын

You can lock a cell from review tab

@abullais0450 Ай бұрын

Just press F4

@anil7271 Жыл бұрын

Drk nhi ho rha kuch problam hoga

@projectometric Жыл бұрын

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

@neerajkumarjoshi4762 Жыл бұрын

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

@ankitrane28 Жыл бұрын

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

@projectometric 7 ай бұрын

What is the formula you are writing? Please mention

@kuldeepsingh-if2hx 11 ай бұрын

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

@projectometric 11 ай бұрын

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 8 ай бұрын

Watched it but not helping

@projectometric 8 ай бұрын

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

@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 brainquisitive@gmail.com, I will check it and return

@abdelmalek9682 5 ай бұрын

WHY THE FIRST FORMULA DIDNT WORK?

@thecivileers6122 11 ай бұрын

Please write the formula here

@projectometric 7 ай бұрын

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

@siddique6419 2 ай бұрын

Formula nahi dikh raha

@projectometric 2 ай бұрын

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.