DataTable Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents a chart data table.

Name

Description

Delete

Deletes the object.

Select

Selects the object.

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

Border

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

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Font

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

Format

Returns the ChartFormat object. Read-only.

HasBorderHorizontal

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

HasBorderOutline

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

HasBorderVertical

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

Parent

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

ShowLegendKey

True if the data label legend key is visible. Read/write Boolean.

Show: