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"
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,736
Members
414,170
Latest member
Mdm

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