Why does this macro color the series on the chart but not the legend, for non-pie charts?

The purpose of the following code is to change the colors of the series in a chart according to the colors of cells with the values. It was originally made for Pie charts and it works for those.

I don't understand most of the code, but I noticed that there's a line in it in order to skip all charts which are not pie. I put that line in comment because I want to use this macro for a stacked column chart. However the problem is that it only changed the colors of the columns, but not the legend. (the legend has the same color as before which doesn't fit the new color of the columns)

Please Login or Register  to view this content.