Gantt Chart showing weekends

Gantt charts are not my strength, so I am not sure what the best ways are to do this. A few thoughts to prompt some discussion:

1) I see several "in cell" Gantt charts that show how to format weekends different from weekdays. Because they are built on conditional formatting of cells, they seem fairly straightforward to implement. Are you opposed to an in-cell charting technique? (http://www.criticaltosuccess.com/tim...hart-in-excel/ ).

2) A Gantt chart is basically a stacked bar chart. Getting "gray sections" to appear as part of those stacked bars is going to involve adding additional data series (meaning additional columns in the spreadsheet). These columns will need formulas to locate weekends and position them correctly. I am not sure how to workout those formulas to get the weekends correctly located, but I am not sure that it will be easy.

3) One example chart I saw added a gray "background" band to show where weekends are along the timeline. This seems easier than adding stacked bars into the existing Gantt chart. The background bands are also stacked bar series, but they are plotted on the secondary axis system and formatted so that the stacked bars extend from top to bottom of the chart. (tutorial here: https://peltiertech.com/Excel/Charts...ticalBand.html though it appears that some of the commands are specific to 2003 and earlier, so you may need to find the equivalent commands in the new interface.)

How would you like to proceed?

Short but useless answer -- yes it is possible. Because the in cell charting version of the Gantt chart seems to be mostly cell functions and conditional formatting based on the results of those functions, automating this for a variety of circumstances is mostly about figuring out all those different formulas. As I noted, I don't use Gantt charts much, so I am not very good with them. I suggest you work through the tutorial. Let us know where you get stuck. If you get it all set up and working and it is not as automatic as you like, post your result and let us know what more you want it to do.

I added a couple of series (wk, we) and moved them to the secondary axis
It takes some effort to synchronize both axis, but it can be done via VBA code.
Is this what you want.

I also checked your formulas in Prelim.Schedule and did some updating.....

I did not yet use any VBA code.
It looks simple, but one has to take many steps.
At this moment I don't see a way to add also holidays (but maybe later)
See my new added worksheet ReadMe and try it yourself.
If you manage to get the weekend bands we can continue to make your gantt chart more flexible.

@croix22,
Did you succeed in adding the gray weekends ?

I gave it a try.
It was to complex for me to put it all in 1 chart.
So I made a second chart added the holidays on that one and moved the second chart exactly on top of the first one.
Not very user friendly, but it does the trick.