This documentation is archived and is not being maintained.

Chart.DataTable Property

Gets a DataTable that represents the chart data table.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in

public DataTable DataTable { get; }

Property Value

A DataTable that represents the chart data table.

The following code example creates a Chart and then uses the HasDataTable and DataTable properties to display a data table in the chart with a border outline.

private void SetDataTableBorder()
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 

    chart1.SetSourceData(this.Range["A1", "B5"], 
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.HasDataTable = true;
    chart1.DataTable.HasBorderOutline = true;