Share via

Chart.HasDataTable Property

  • Article
Excel Developer Reference

True if the chart has a data table. Read/write Boolean.

Syntax

expression.HasDataTable

expression   A variable that represents a Chart object.

Example

This example causes the embedded chart data table to be displayed with an outline border and no cell borders.

Visual Basic for Applications 
  With Worksheets(1).ChartObjects(1).Chart
    .HasDataTable = True
    With .DataTable
        .HasBorderHorizontal = False
        .HasBorderVertical = False
        .HasBorderOutline = True
    End With
End With

See Also