Excel Automate Gantt function

robocop1906

Board Regular
Joined
Jan 15, 2003
Messages
143
Is there a slick automated way to create a Gantt chart based on a start and finish date in Excel?

Follow me if you can.....say I imput a timeline header row from july 07 to july 08 from Cells D1-O1

Then in columns B= Start dates and in column C= End dates

I would image there would be some way to imput formulas in cells below the header row of D1-O1 down based on the start and finish date in colums B & C that could enter a value that could be used to conditional format a gantt chart.

Hope this is clear.

Maybe something like this for cell D2.....if cell D1 is not between cell B2 and cell C2 then enter "-", if true then enter "1"
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,876
Messages
5,834,194
Members
430,263
Latest member
abz54

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top