ChartSheet.DataTable Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a DataTable object that represents the ChartSheet data table.
public:
property Microsoft::Office::Interop::Excel::DataTable ^ DataTable { Microsoft::Office::Interop::Excel::DataTable ^ get(); };
public Microsoft.Office.Interop.Excel.DataTable DataTable { get; }
member this.DataTable : Microsoft.Office.Interop.Excel.DataTable
Public ReadOnly Property DataTable As DataTable
Property Value
A DataTable object that represents the ChartSheet data table.
Examples
The following code example uses the DataTable property of the current Microsoft.Office.Tools.Excel.ChartSheet to display a data table in the chart with a border outline.
private void DisplayDataTable()
{
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.xl3DColumn;
this.HasDataTable = true;
this.DataTable.HasBorderOutline = true;
}
Private Sub DisplayDataTable()
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.xl3DColumn
Me.HasDataTable = True
Me.DataTable.HasBorderOutline = True
End Sub