Class DataTable (PowerPoint VBA)

The class DataTable represents a chart data table.

Set

To use a DataTable class variable it first needs to be instantiated, for example

Dim dte as DataTable
Set dte = ActiveWindow.RangeFromPoint.Chart.DataTable

DataTable class variables can be set using the Chart.DataTable procedure.

Border

Returns the border of the object.

Dim cbrBorder As ChartBorder
Set cbrBorder = ActiveWindow.RangeFromPoint.Chart.DataTable.Border

Delete

Deletes the object.

ActiveWindow.RangeFromPoint.Chart.DataTable.Delete

Font

Returns the font of the specified object.

Dim cftFont As ChartFont
Set cftFont = ActiveWindow.RangeFromPoint.Chart.DataTable.Font

Format

Returns the line, fill, and effect formatting for the object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveWindow.RangeFromPoint.Chart.DataTable.Format

HasBorderHorizontal

True if the chart data table has horizontal cell borders.

ActivePresentation.Slides(1).Shapes(1).Chart.DataTable.HasBorderHorizontal = True

HasBorderOutline

True if the chart data table has outline borders.

ActivePresentation.Slides(1).Shapes(1).Chart.DataTable.HasBorderOutline = True

HasBorderVertical

True if the chart data table has vertical cell borders.

ActivePresentation.Slides(1).Shapes(1).Chart.DataTable.HasBorderVertical = True

Parent

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

Select

Selects the object.

ActiveWindow.RangeFromPoint.Chart.DataTable.Select

ShowLegendKey

True if the data label legend key is visible.

ActiveWindow.RangeFromPoint.Chart.DataTable.ShowLegendKey = True