Apply Color to chart based on Data source text color

Hi All,

I have this macro which colors the interior of each column in my column charts. My issue is that some rows are hidden because of na data. For example: row 51 will be visible because there is data. Row 51 text is blue so the column in the chart will be colored blue. Row 52-53 are na() so they will be hidden and not appear on the chart. Row 54 has data and it is colored red, but the macro is picking the color from Row 52 and not row 54. any way to skip the hidden rows?

Please Login or Register  to view this content.

or another macro to apply the text color of the data range to the columns in the graph.