DataTable.HasBorderHorizontal Property

  • Article
Excel Developer Reference

True if the chart data table has horizontal cell borders. Read/write Boolean.

Syntax

expression.HasBorderHorizontal

expression   A variable that represents a DataTable 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