ChartSheet.Legend Property (2007 System)
Gets a Legend that represents the legend for the Microsoft.Office.Tools.Excel.ChartSheet.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property Legend As Legend
'Usage
Dim instance As ChartSheet
Dim value As Legend
value = instance.Legend
[BrowsableAttribute(false)]
public Legend Legend { get; }
[BrowsableAttribute(false)]
public:
property Legend^ Legend {
Legend^ get ();
}
public function get Legend () : Legend
Property Value
Type: 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.