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);
}
Return to top
Show: