Chart.Legend Property

Gets a Legend object that represents the legend for the chart.

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

Syntax

'Declaration
ReadOnly Property Legend As Legend

Legend Legend { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Legend
A Legend object that represents the legend for the chart.

Examples

The following code example creates a Chart and then uses the Legend property to modify the color of the legend border.

Private Sub SetLegendBorderColor()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    Chart1.Legend.Border.Color = _
            ColorTranslator.ToOle(Color.Green)
End Sub

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

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.Legend.Border.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

Chart Interface

Microsoft.Office.Tools.Excel Namespace