This documentation is archived and is not being maintained.

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