VBA to colour data labels same as line colour - dynamic chart

Hi
I have a dynamic chart with a varying number of data series.
I would like to create a macro to make the data labels colour match the line colour.

I have tried the code below, but it seems to match 1 data series, but the rest - the data labels are coloured white?
Any ideas on how to do this?

Thanks

Please Login or Register  to view this content.

Anyone...?

hi Jabba69,

Please Login or Register  to view this content.

or with you syntax:

Please Login or Register  to view this content.

Thanks watersev
I tried the second syntax, and it did the same as my code - coloured data labels in white.

But it got me thinking, and a bit of playing around made me realise that it was making white for the data series that were automatically allocated a colour. When I select a series and pick a line colour, the code works (yours and mine).

I can work with this, although ideally it be better if it automatically recognised the line colour (even if auto generated).

Thanks