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.ActiveChart
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
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.