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

See also

Window Object