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
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.