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.