WorkbookBase.ActiveChart Property
Gets a Microsoft.Office.Interop.Excel.Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it is either selected or activated. When no chart is active, this property returns nulla null reference (Nothing in Visual Basic).
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property ActiveChart As Chart
Get
public Chart ActiveChart { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Chart
A Microsoft.Office.Interop.Excel.Chart object that represents the active chart; nulla null reference (Nothing in Visual Basic) if no chart is active.
Examples
The following code example uses the ActiveChart property to get the active chart for the current workbook and then makes the title of the chart invisible.
This example is for a document-level customization.
Private Sub HideActiveChartTitle()
If Not (Me.ActiveChart Is Nothing) Then
Me.ActiveChart.HasTitle = False
End If
End Sub
private void HideActiveChartTitle()
{
if (this.ActiveChart != null)
{
this.ActiveChart.HasTitle = false;
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.