Stacked Chart - Change Bar Colors Based on Date (X-Axis)

Hi all;

I am wanting the colors of the bars in a stacked chart to change based on the date in the X Axis. As the current date arrives, the stacked bar needs to change to various blue shades. If the date is in the future, the stacked bar needs to be various grey shades. Can anyone suggest how this can be done? If it requires VBA could you please also include a snippet example? I have an image of what I am trying to achieve attached.

Thanks so much for sharing your expertise!

JL