Workbook.ActiveChart property (Excel)
Returns a Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it's either selected or activated. When no chart is active, this property returns Nothing.
expression A variable that represents a Workbook object.
If you don't specify an object qualifier, this property returns the active chart in the active workbook.
This example turns on the legend for the active chart.
ActiveChart.HasLegend = True
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.