Export (0) Print
Expand All
Expand Minimize

ChartSheetBase.Legend Property

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

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

public Legend Legend { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Legend
A Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheetBase.

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);
}

Show:
© 2015 Microsoft