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

Join this channel to get access to perks:

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

[thekamuigarcia]

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

[AbdurRahim-ymbu]

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.

[syamaldas]

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

[lyn]

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

[PixBlend]

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

[sudhirbhalerao]

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

[syamaldas]

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

[mohd.ibrahim]

Nice video sir
But kuch doudt h please guide me

[sachinjha]

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

[shriyashdivase]

Which formula you used for that DAYS column?

[peshawarhouses]

Link for download this sheet please... Thank you

[manishmanchhani]

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

[VIPINRAJPUT-xt]

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

[kuldeepsingh-ifhx]

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

[neerajkumarjoshi]

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

[royalforce]

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

[ankitrane]

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