Skip to end of metadata
Go to start of metadata

Description

A ChartDataTable object represents a chart's data table. A data table is a grid that can be added to some charts that contains the numeric data used to create the chart. The data table is usually attached to the chart's category axis, replacing the tick-mark labels on the axis.

C#
vb.net

Remarks

To return a ChartDataTable, use Chart.DataTable.

Properties

Name

Description

BorderLine

Returns a ChartLine object representing the border around the data table.

Font

Sets or returns the font for text in the data table.

Height

Sets or returns the height of the data table, in units of 1/4000 of the chart area.

(This property has no effect for files opened in Excel 2007 and later.)

ShowHorizontalBorders

Sets or returns whether the chart's data table will display horizontal grid lines.

ShowLegendKeys

Sets or returns whether the data table will include legend keys next to series titles.

ShowOutlineBorders

Sets or returns whether the data table will display outline gridlines.

ShowVerticalBorders

Sets or returns whether the chart's data table will display vertical grid lines.

Visible

Sets or returns whether to display a data table (in place of category axis tick mark labels). Data tables are not available for all chart types.

Width

Sets or returns the width of the data table, in units of 1/4000 of the chart area.

(This property has no effect for files opened in Excel 2007 and later.)

X

Sets or returns the x coordinate of the upper left corner of the data table, in units of 1/4000 of the chart area.

(This property has no effect for files opened in Excel 2007 and later.)

Y

Sets or returns the y coordinate of the upper left corner of the data table, in units of 1/4000 of the chart area.

(This property has no effect for files opened in Excel 2007 and later.)

  • No labels