Dela via


ChartSheet.ChartTitle Property

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

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
ReadOnly Property ChartTitle As ChartTitle
    Get
ChartTitle ChartTitle { get; }

Property Value

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

Examples

The following code example uses the ChartTitle property of the current Microsoft.Office.Tools.Excel.ChartSheet 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

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace