Excel 2016 SurfaceChart Legend.LegendEntries() Text Retrieval?

[SunDogs]

Hello,

I'm working with 3D Surface Charts using Personal Macro WB.
The 3D chart is in a Chart Sheet and NOT embedded.

I need to put the LegendEntry(12) text into a variable.
I can Bold the text using

ActiveChart.Legend.LegendEntries(12).Font.Bold = True

But I can't figure out how to retrieve the text.

Thanks for your help!

 

[thisoldman]

Do you want the series name?

ActiveChart.SeriesCollection(12).Name

 

[SunDogs]

Hi thisoldman, thanks but no I'm not looking for the series name. My legend is based on the y axis and they are power level bands.
Thank you for trying!

 

[thisoldman]

I don't understand how you have a legend entry that is not a series name.

"Each legend entry has two parts: the text of the entry, which is the name of the series associated with the legend entry; and an entry marker, which visually links the legend entry with its associated series or trendline in the chart."
​

from: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/legendentry-object-excel

 

[SunDogs]

Z is the depth and the series, y is the value of the series, x is the series range. The y values are the band values. I would think there is a way to ping the legend to get these values...but maybe there isn't. It is strange that I can bold the text in the series, so one would think that I should be able to retrieve the text also. So, no worries if you don't know.
Thanks!