Retrieve the name of a series from a GCD using VBA

Hello

I'm looking to automatically format a GCD.

For this, I need to retrieve the name of each data series and assign it a color through a separate table that I define.

Problem: In my macro, when I select the GCD series to retrieve the name, I always get "Empty" as a response:

ActiveChart.FullSeriesCollection(seriesNumber).Name=SeriesName
with
seriesNumber: the series number
SeriesName: the name I am trying to retrieve... and which is always "Empty"

Can someone help me?

Thanks in advance