Automatic Gantt Chart formula preparation

Hello,

Kindly suggest a formula to create automatic Gantt chart as per requirement below.

1. Gantt chart for Start date to End date with one color
2. Gantt chart for Delayed date with different color(this chart will start from end date to delayed date)

Kindly refer the attached excel file, which i created formula. I am not able to cerate formula exactly for my requirement.

Please refer the attached excel file & try to edit as per the requirement mentioned.

Thanks for the support in advance.

BR,
Vinod

Hello
Take a look at the 'Example' sheet in the attached reply. Does this formula work as required?

Hope this helps.
DBY

Hello DBY,

Thanks a lot indeed for your prompt reply. It is working as per the requirement.

I am facing small problem now, which is on color for P & D..I just copy pasted the formula in my excel file & It gives P (progress) & D(delay) as per the requirement. But not giving the color code. that means only white color.

Could you please suggest how to give the different color code for P & D?

Thanks for your support in advance.

BR,
Vinod

Hello
I've applied the formulas to your 'Project Name' sheet and it seems to be OK for me, so I'm not quite sure what the problem you are having is. One of your Start Dates is greater than the End Date, which I've indicated on the attached reply. If this does not solve the problem upload another example file highlighting the problem

DBY

Hello DBY,

Kindly find the attached excel file, which i further refined based on current requirement. I am still facing issue with Color code if i change Formula Letter from Progress to P. Kindly go through it and suggest a solution for the requirement.

I have added 2 additional requirement. Kindly ignore if that is complex.

Thanks once again for your support.

Have a nice day!

Regards,
Vinod

Hello DBY,

I am glad to inform you that i got color code requirement & found easy :-)

Please commnet on my additional requirement alone when you get free time.

Regards,
Vinod

Hello Vinod
The Conditional formatting along M3:AA3 is quite straightforward and I've applied the formula. Not sure exactly what you want with the calendar but I've inserted a Calendar Control with some VBA code to insert the selected date into the Start Date range. This does mean, however, that the workbook has to be Macro Enabled.

Please note that my VBA skills are limited, so I'm not sure how good the code is but it seems to work OK.

DBY

Hello DBY,

Thanks a lot for the prompt reply. I am almost inthe stage of finalisation of this file.

I am facing few more issues related to formula error & Conditional formatting.

Kindly go through the attached file ( I have mentioned requirement in the attachment). Please help me the currect the formula error. I am not able to solve the formaula eror.

I have updated the formula as per the requirement & formula error happened in the formula updation.

Thanks a lot indeed for your support.

Regards,
Vinod

Hello Vinod
I've amended your last file to omit the errors and made a few changes that you might find useful. I've included a new sheet with an alternative Gantt chart without the formulas in the cells, just conditional formatting, this would reduce the chances of formula errors appearing.

Hope this helps.
DBY

Dear DYB,

It is great help & really learned many formulas with your support.

I would like to have one more formula, which i failed to create.

Kindly go throught the attached excel file, in which i mentioned the formula requirement.

I really appreciate your patiance & Support

Regards,
Vinod

Hello Vinod
Glad you're finding the forum useful. I've applied some formulas and conditional formatting as I think you require. Please see attached file.

DBY

Dear DBY,

Everything parfect now. I could create the file very well with your timely support.

Thanks a lot indeed.

Good day :-)

Regards,
Vinod

Dear DYB,

Kindly suggest an option to make a cell blank as per the requirement shown in the attached excel file.

Regards,
Vinod

Hello Vinod

See attached reply for a couple of possible solutions.

DBY

Thanks a lot DBY. Its working well

Good day :-)

Regards,
Vinod

Hello DBY,

Hope you are doing good!

I need your support for one of the new requirement of excel rows filtering with some formula.
I have tried with some of the formula but failed to meet the objective. Kindly support.

I have mentioned the requirement in the attached excel file for the row filtering. (pl refer Excel try 1 file)

Appreciate your support in advance. Good day!

Regards,
Vinod

Hello Vinod
I'm keeping well, thank you, I hope you also. If I've understood you correctly, I think you could do this by either having formulas in a helper column and sorting on that, or by sorting the 3 columns with the Number filters option 'Between'. See attached. Just a note, although you original post in this thread was technically about charting this isn't, so it may have to be moved to another sub forum, General or Formulas and Functions perhaps.

DBY