ChartSheet.Legend Property

Definition

Gets a Legend that represents the legend for the ChartSheet.

public:
 property Microsoft::Office::Interop::Excel::Legend ^ Legend { Microsoft::Office::Interop::Excel::Legend ^ get(); };
public Microsoft.Office.Interop.Excel.Legend Legend { get; }
member this.Legend : Microsoft.Office.Interop.Excel.Legend
Public ReadOnly Property Legend As Legend

Property Value

A Legend that represents the legend for the ChartSheet.

Examples

The following code example uses the Legend property to modify the color of the legend border in the current Microsoft.Office.Tools.Excel.ChartSheet.

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

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DBarClustered;

    this.Legend.Border.Color =
        ColorTranslator.ToOle(Color.Green);
}
Private Sub SetLegendColor()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DBarClustered

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

Applies to