ChartSheetBase.ChartTitle Property

Gets a ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel.ChartSheetBase.

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 ChartTitle As ChartTitle
    Get

public ChartTitle ChartTitle { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.ChartTitle
A ChartTitle that represents the title of the specified Microsoft.Office.Tools.Excel.ChartSheetBase.

Examples

The following code example uses the ChartTitle property of the current Microsoft.Office.Tools.Excel.ChartSheetBase to modify the font color of the title.

Private Sub SetTitleColor()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.ChartWizard(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlChartType.xl3DColumn, PlotBy:=Excel.XlRowCol.xlColumns, _
        HasLegend:=False, Title:="Revised chart")

    Me.ChartTitle.Font.Color = _
            ColorTranslator.ToOle(Color.Green)
End Sub

private void SetTitleColor()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.ChartWizard(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlChartType.xl3DColumn, missing,
        Excel.XlRowCol.xlColumns, missing, missing, false,
        "Revised chart", missing, missing, missing);

    this.ChartTitle.Font.Color =
        ColorTranslator.ToOle(Color.Green);
}

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

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace