WorkbookBase.ActiveChart Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a 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 null.
public:
property Microsoft::Office::Interop::Excel::Chart ^ ActiveChart { Microsoft::Office::Interop::Excel::Chart ^ get(); };public Microsoft.Office.Interop.Excel.Chart ActiveChart { get; }member this.ActiveChart : Microsoft.Office.Interop.Excel.ChartPublic ReadOnly Property ActiveChart As ChartProperty Value
A Chart object that represents the active chart; null 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 void HideActiveChartTitle()
{
if (this.ActiveChart != null)
{
this.ActiveChart.HasTitle = false;
}
}
Private Sub HideActiveChartTitle()
If Not (Me.ActiveChart Is Nothing) Then
Me.ActiveChart.HasTitle = False
End If
End Sub