Powerpoint: change chart column fill color

[pbassett]

My chart shows 12 columns of data for the Calendar year in dark blue.

I want to show future months (forecast data) in light blue, and since there are several charts, I want to automate this, but I can't figure out how to set Data Series fill color.

I recorded a Macro doing this but all it recorded was ActiveWindow.Selection.Unselect