How to match colors of data series and data labels in a buble chart

[FrancoisXL]

Hi,

I have a bubble chart with approx. 40 bubbles and labels are in black. I am using Excel 2010.
How can I have colors of data series (the bubbles) and data labels match ?

I have found on MrExcel an answer that copies the color of the border to the label, but I do not have borders. I need to copy the color of the bubble.

Can anybody help ?

Thank you in advance
Francois


Sub legend_color()Dim SRS As SeriesWith ActiveChart For Each SRS In .SeriesCollection SRS.DataLabels.Font.ColorIndex = SRS.Border.ColorIndex Next SRSEnd WithEnd Sub</pre>