Excel colors to graph

Experts:

I would like to apply an Excel color scheme automatically to a graph.    That is, in attached spreadsheet, cells A25:C25 = blue, A26:C26 = yellow, A27:C27=red... I would like to apply the same colors to a graph.

When googling for any existing solution, I came across a spreadsheet (original source:  http://datapigtechnologies.com/blog/index.php/automatically-set-chart-series-colors-to-match-source-cell-colors/) which applies cell colors to the graph; however, underlying data is structured vertically vs. my data is structured horizontally.    Again, please see attached XLS... a picture is worth a 1000 words.

Does anyone know how to modify the existing VBA in order to accomplished the envisioned process?   By the way, I am totally open to a different solution that the one included in the XLS.

Thanks,
EEH
Cell-Colors-Applied-to-Graph.xlsm