Is Chart Series in Legend - VBA Check

[erock24]

Is it possible to check if a chart series is in the legend? I have a chart that has 6 series charted, but only 4 of those are represented in the legend as an entry. Is there a VBA function that can loop the chart series and test if they are represented in the legend?

Thank you,

 

[RoryA]

As far as I know, no. There is no way to read the text of a legend entry in VBA and you can't refer to them by name, only by index number.

 

[erock24]

Thank you for the reply. Seems like this would be a very useful enhancement. Is there a place to post recommendations such as these or is that a lost cause??

 

[RoryA]

Given how low VBA is in Microsoft’s estimation, I wouldn’t hold your breath!
I can’t recall offhand what the current version of uservoice is for making suggestions, I’m afraid.