Partager via

ChartSheetBase.Legend Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets a Legend that represents the legend for the ChartSheetBase.

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

Legend

A Legend that represents the legend for the ChartSheetBase.

Examples

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

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