Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Application.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 an Application 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
© 2015 Microsoft