legendentries

[Guest]

The following code applied to an embedded chart in a chartsheet fails with
error message 'Unable to get the Legendentries property of the Legendclass'.
Error # 1004.

For Each le In ActiveChart.Legend.LegendEntries
le.LegendKey.Border.LineStyle = xlNone
Next

Any idea why?

ojv

 

[Peter T]

Are you sure your chart has a legend,

If ActiveChart.HasLegend Then

Regards,
Peter T

 

[Tom Ogilvy]

It worked fine for me. What type of chart are you working with?

 

[Guest]

I'm trying it on a surface contour chart.

It worked fine for me. What type of chart are you working with?

 

[Rob van Gelder]

The Legend box needs to showing.

ActiveChart.HasLegend = True