ChartTitle ChartType CodeName Creator DataTable DepthPercent DisplayBlanksAs Elevation Floor GapDepth HasAxis HasDataTable HasLegend HasTitle HeightPercent Hyperlinks 索引 图例 MailEnvelope Name Next PageSetup Parent Perspective PivotLayout PlotArea PlotBy ...
_Chart.DataTable 属性 参考 反馈 本文内容 定义 适用于 定义 命名空间: Microsoft.Office.Interop.Excel 程序集: Microsoft.Office.Interop.Excel.dll 返回表示 DataTable 图表数据表的 对象。 C# 复制 public Microsoft.Office.Interop.Excel.DataTable DataTable { get; } 属性值 DataTable 适用于 ...
expression:一个表示 Chart 对象的变量。 示例 本示例使嵌入图表模拟运算表显示时带有外边框,但无单元格边框。 VB 复制 With Worksheets(1).ChartObjects(1).Chart .HasDataTable = True With .DataTable .HasBorderHorizontal = False .HasBorderVertical = False .HasBorderOutline = True End With End With ...
1.1. Show the Data Table Using the ‘Quick Layout’ Option Steps: Click the chart and go toChart Design>Quick Layout. Choose a default chart layout that includes a data table. You will see the chart containing the data table. 1.2. Use the ‘Add Chart Element’ Option to Show Data Tabl...
ChartBinOptions ChartBorder ChartBoxwhiskerOptions ChartCollection ChartDataLabel ChartDataLabelFormat ChartDataLabels ChartDataTable ChartDataTableFormat ChartDeactivatedEventArgs ChartDeletedEventArgs ChartErrorBars ChartErrorBarsFormat ChartFill ChartFont ChartFormatString ChartGridlines ChartGridlinesFormat ChartLege...
TypeScript კოპირება toJSON(): Excel.Interfaces.ChartDataTableFormatData; Returns Excel.Interfaces.ChartDataTableFormatData ითანამშრომლეთ ჩვენთან GitHub-ზე ამ შიგთავსის წყარ...
public Microsoft.Office.Interop.Excel.DataTable DataTable { get; } Property Value DataTable A DataTable that represents the chart data table. Examples The following code example creates a Chart and then uses the HasDataTable and DataTable properties to display a data table in the chart with ...
ChartType 属性:返回或设置图表类型。 XlChartType 类型,可读写。 CodeName 属性:返回对象的代码名。 只读的字符串。 Creator 属性:返回一个 32 位整数,该整数指示在其中创建了此对象的应用程序。 只读 Long。 DataTable 属性:返回表示图表数据表的 DataTable 对象。 此为只读属性。
The data table of the chart remains the same. Read More: How to Change X-Axis Values in Excel Method 3 – Sorting the Data Table to Sort Chart Data Steps: Select the dataset from cells B4:C9 and go to the Insert tab. From the Tables group, select Table. A Create Table dialog box...
ChartAxisTitleFormat ChartBinOptions ChartBorder ChartBoxwhiskerOptions ChartCollection ChartDataLabel ChartDataLabelAnchor ChartDataLabelFormat ChartDataLabels ChartDataTable ChartDataTableFormat ChartDeactivatedEventArgs ChartDeletedEventArgs ChartErrorBars ChartErrorBarsFormat ChartFill ChartFont ChartFormatString Cha...