Update line chart series colors

[Apple Ling]

Hi,

I have a combination bar and line chart. I need to update the chart color based on the color stored at sheet1. However, i just manage to update the bar but the macro seem not working for the line.

Please Login or Register  to view this content.

Attached here with my sample file. I hope someone can help. Thank you very much

[Andy Pope]

Two problems with the code.
First the mis spelling of a variable name meant not line formatting was being done. You had MyColor instead of MyColour.
Once that is corrected you need to change the border property for lines not the fill.

Please Login or Register  to view this content.

[Apple Ling]

Thank you very much