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

[tahi.laci]

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.

[skywriter]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[tahi.laci]

I've included a sheet before the macro runs and one after. I added an extra pie chart to show how the legend would look if it was done correctly. The legend of the column chart should have the same colors as the legend of the pie chart. Order doesn't matter.

[skywriter]

Try this.

Please Login or Register  to view this content.

[tahi.laci]

Thanks that worked. And probably the previous advice about the sample workbook was good as well.

Can you point to me a website where I can learn about these type of macros? (macros containing object & series type variables). Ideally they would have a few examples of what other objects there are other than ChartObject and a few examples of characteristics we can read and write. (eg .Interior.Color, .forecolor.RGB)