Partilhar via


ChartSheet.Legend Property

Gets a Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheet.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
  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 that represents the legend for the Microsoft.Office.Tools.Excel.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 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
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);
}

.NET Framework Security

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace