How do you vary colors of bar graph by day of the week?

I feel really stupid for this because I am searching all over and not seeing answers for this. Like is this a basic option I am missing that is so obvious nobody asks it?

Basically I have a bar graph for data points throughout the year, I want something like Mondays red, tuesdays blue, wednesdays green, etc etc

The option to "vary colors by point" seems to alternate every 14 or so colors and there doesn't seem to be a way to change the interval, that I can tell.

Obviously I can manually change colors but this is excel and there has gotta be a way to alternate that rather than do it for each individual point. Especially since I have multiple "yearly" charts I'd like to do this for.