Class DataTable (Excel VBA)

The class DataTable represents a chart data table.

Border

Returns a Border object that represents the border of the object.

Delete

Deletes the object.

Font

Returns a Font object that represents the font of the specified object.

Format

Returns the ChartFormat object.

HasBorderHorizontal

True if the chart data table has horizontal cell borders.

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

HasBorderOutline

True if the chart data table has outline borders.

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

HasBorderVertical

True if the chart data table has vertical cell borders.

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

Parent

Returns the parent object for the specified object. Read-only.

Select

Selects the object.

ShowLegendKey

True if the data label legend key is visible.