Export (0) Print
Expand All
Expand Minimize

Application.ActiveChart Property

Office 2007
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.

Syntax

expression.ActiveChart

expression   A variable that represents an Application object.

Remarks

If you don't specify an object qualifier, this property returns the active chart in the active workbook.

Example

This example turns on the legend for the active chart.

Visual Basic for Applications
ActiveChart.HasLegend = True



Community Additions

ADD
Show:
© 2014 Microsoft