Hi,
I saw this example for how to set chart series colors to match source cell fill colors. The example takes the first value's fill color for each series. How do I modify it to set the color of the series to automatically match the first column that would be the series name column? (In the example, it would match column B where Q1, Q2, Q3 and Q4 are)
My data is usually like this:
This is the example code I would like to modify (so that it would pick the font colors from the column that has name_1,name_2,...,name_i)
Thank you for any help.
I assume it's to do with the part with
FormulaSplit = Split(MySeries.Formula, ",")
Set SourceRange = Range(FormulaSplit(2)).Item(1)
SourceRangeColor = SourceRange.Interior.Color -> SourceRange.Font.Color
Bookmarks