Excel.Interfaces.ChartSeriesData interface

描述通过调用 "chartSeries ()" 返回的数据的接口。An interface describing the data returned by calling "chartSeries.toJSON()".

属性

axisGroup

返回或设置指定系列的组。Returns or sets the group for the specified series. 读/写Read/Write

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

binOptions

封装直方图图表和排列图表的 bin 选项。Encapsulates the bin options for histogram charts and pareto charts. 只读。Read-only.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

boxwhiskerOptions

封装箱和形图的选项。Encapsulates the options for the box and whisker charts. 只读。Read-only.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

bubbleScale

该值可以是 0 (零) 到300之间的整数值, 表示默认大小的百分比。This can be an integer value from 0 (zero) to 300, representing the percentage of the default size. 此属性仅适用于气泡图。This property only applies to bubble charts. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

chartType

表示系列的图表类型。Represents the chart type of a series. 有关详细信息, 请参阅 ChartType。See Excel.ChartType for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

dataLabels

表示系列中所有数据标签的集合。Represents a collection of all dataLabels in the series.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

doughnutHoleSize

表示图表系列的圆环孔大小。Represents the doughnut hole size of a chart series. 仅对圆环图和分离型圆环图有效。Only valid on doughnut and doughnutExploded charts. 对无效图表引发无效参数异常。Throws an invalid argument exception on invalid charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

explosion

返回或设置饼图或圆环图切片的分解程度值。Returns or sets the explosion value for a pie-chart or doughnut-chart slice. 如果未分解(切片尖端位于饼图中心),则返回 0(零)。Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie). 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

filtered

该布尔值表示是否筛选系列。Boolean value representing if the series is filtered or not. 不适用于曲面图。Not applicable for surface charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

firstSliceAngle

返回或设置第一个饼图或圆环图切片的角度,以度为单位(从垂直方向起为顺时针)。Returns or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). 只适用于饼图、三维饼图和圆环图。Applies only to pie, 3-D pie, and doughnut charts. 可以是 0 到 360 之间的值。Can be a value from 0 through 360. 读/写Read/Write

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

format

表示图表系列的格式,包括填充和线条格式。Represents the formatting of a chart series, which includes fill and line formatting. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

gapWidth

表示图表系列的间隙宽度。Represents the gap width of a chart series. 仅对条形图和柱形图有效, 以及折线图和饼图的特定类。Only valid on bar and column charts, as well as specific classes of line and pie charts. 对无效图表引发无效参数异常。Throws an invalid argument exception on invalid charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

gradientMaximumColor

返回或设置区域地图图表系列的最大值的颜色。Returns or sets the color for maximum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMaximumType

返回或设置区域地图图表系列的最大值的类型。Returns or sets the type for maximum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMaximumValue

返回或设置区域地图图表系列的最大值。Returns or sets the maximum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMidpointColor

返回或设置区域地图图表系列的中点值的颜色。Returns or sets the color for midpoint value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMidpointType

返回或设置区域地图图表系列的中间值的类型。Returns or sets the type for midpoint value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMidpointValue

返回或设置区域地图图表系列的中间值。Returns or sets the midpoint value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMinimumColor

返回或设置区域地图图表系列的最小值的颜色。Returns or sets the color for minimum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMinimumType

返回或设置区域地图图表系列的最小值的类型。Returns or sets the type for minimum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMinimumValue

返回或设置区域地图图表系列的最小值。Returns or sets the minimum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientStyle

返回或设置区域地图图表的系列渐变样式。Returns or sets series gradient style of a region map chart. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

hasDataLabels

该布尔值表示系列是否具有数据标签。Boolean value representing if the series has data labels or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

invertColor

返回或设置系列中负数据点的填充颜色。Returns or sets the fill color for negative data points in a series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

invertIfNegative

如果 Excel 在值为负数时反转项目中的图案,则为 True。True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

mapOptions

封装区域映射图的选项。Encapsulates the options for a region map chart. 只读。Read-only.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

markerBackgroundColor

表示图表系列的标记背景色。Represents markers background color of a chart series.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

markerForegroundColor

表示图表系列的标记前景色。Represents markers foreground color of a chart series.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

markerSize

表示图表系列的标记大小。Represents marker size of a chart series.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

markerStyle

表示图表系列的标记类型。Represents marker style of a chart series. 有关详细信息, 请参阅 ChartMarkerStyle。See Excel.ChartMarkerStyle for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

name

表示图表中某个系列的名称。Represents the name of a series in a chart.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

overlap

指定条柱的摆放方式。Specifies how bars and columns are positioned. 可以是–100到100之间的值。Can be a value between –100 and 100. 只适用于二维条形图和二维柱形图。Applies only to 2-D bar and 2-D column charts. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

parentLabelStrategy

返回或设置树状图图表的系列父标签策略区域。Returns or sets the series parent label strategy area for a treemap chart. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

plotOrder

表示图表组中某个图表系列的绘制顺序。Represents the plot order of a chart series within the chart group.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

points

表示系列中所有数据点的集合。Represents a collection of all points in the series. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

secondPlotSize

返回或设置复合饼图或复合条饼图的辅助分区的大小,以占主饼图大小的百分比表示。Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. 可以是 5 到 200 之间的值。Can be a value from 5 to 200. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showConnectorLines

指定在瀑布图中是否显示连接符线。Specifies whether or not connector lines are shown in waterfall charts. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

showLeaderLines

指定是否为系列中的每个数据标签显示引导线。Specifies whether or not leader lines are displayed for each data label in the series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

showShadow

表示系列是否具有阴影的布尔值。Boolean value representing if the series has a shadow or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

smooth

该布尔值表示系列是否平滑。Boolean value representing if the series is smooth or not. 仅适用于折线图和散点图。Only applicable to line and scatter charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

splitType

返回或设置复合饼图或复合条饼图中两个分区的拆分方式。Returns or sets the way the two sections of either a pie of pie chart or a bar of pie chart are split. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

splitValue

返回或设置用于分隔复合饼图或复合条饼图的两个节的阈值。Returns or sets the threshold value that separates two sections of either a pie-of-pie chart or a bar-of-pie chart. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

trendlines

表示系列中趋势线的集合。Represents a collection of trendlines in the series. 只读。Read-only.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

varyByCategories

如果 Excel 为每个数据标记分配不同的颜色或图案,则为 True。True if Microsoft Excel assigns a different color or pattern to each data marker. 图表必须只包含一个系列。The chart must contain only one series. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

xErrorBars

表示图表系列的误差条形图对象。Represents the error bar object of a chart series.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

yErrorBars

表示图表系列的误差条形图对象。Represents the error bar object of a chart series.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

属性详细信息

axisGroup

返回或设置指定系列的组。Returns or sets the group for the specified series. 读/写Read/Write

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

axisGroup?: Excel.ChartAxisGroup | "Primary" | "Secondary";

属性值

Excel.ChartAxisGroup | "Primary" | "Secondary"

binOptions

封装直方图图表和排列图表的 bin 选项。Encapsulates the bin options for histogram charts and pareto charts. 只读。Read-only.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

binOptions?: Excel.Interfaces.ChartBinOptionsData;

属性值

boxwhiskerOptions

封装箱和形图的选项。Encapsulates the options for the box and whisker charts. 只读。Read-only.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

boxwhiskerOptions?: Excel.Interfaces.ChartBoxwhiskerOptionsData;

属性值

bubbleScale

该值可以是 0 (零) 到300之间的整数值, 表示默认大小的百分比。This can be an integer value from 0 (zero) to 300, representing the percentage of the default size. 此属性仅适用于气泡图。This property only applies to bubble charts. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

bubbleScale?: number;

属性值

number

chartType

表示系列的图表类型。Represents the chart type of a series. 有关详细信息, 请参阅 ChartType。See Excel.ChartType for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

chartType?: Excel.ChartType | "Invalid" | "ColumnClustered" | "ColumnStacked" | "ColumnStacked100" | "3DColumnClustered" | "3DColumnStacked" | "3DColumnStacked100" | "BarClustered" | "BarStacked" | "BarStacked100" | "3DBarClustered" | "3DBarStacked" | "3DBarStacked100" | "LineStacked" | "LineStacked100" | "LineMarkers" | "LineMarkersStacked" | "LineMarkersStacked100" | "PieOfPie" | "PieExploded" | "3DPieExploded" | "BarOfPie" | "XYScatterSmooth" | "XYScatterSmoothNoMarkers" | "XYScatterLines" | "XYScatterLinesNoMarkers" | "AreaStacked" | "AreaStacked100" | "3DAreaStacked" | "3DAreaStacked100" | "DoughnutExploded" | "RadarMarkers" | "RadarFilled" | "Surface" | "SurfaceWireframe" | "SurfaceTopView" | "SurfaceTopViewWireframe" | "Bubble" | "Bubble3DEffect" | "StockHLC" | "StockOHLC" | "StockVHLC" | "StockVOHLC" | "CylinderColClustered" | "CylinderColStacked" | "CylinderColStacked100" | "CylinderBarClustered" | "CylinderBarStacked" | "CylinderBarStacked100" | "CylinderCol" | "ConeColClustered" | "ConeColStacked" | "ConeColStacked100" | "ConeBarClustered" | "ConeBarStacked" | "ConeBarStacked100" | "ConeCol" | "PyramidColClustered" | "PyramidColStacked" | "PyramidColStacked100" | "PyramidBarClustered" | "PyramidBarStacked" | "PyramidBarStacked100" | "PyramidCol" | "3DColumn" | "Line" | "3DLine" | "3DPie" | "Pie" | "XYScatter" | "3DArea" | "Area" | "Doughnut" | "Radar" | "Histogram" | "Boxwhisker" | "Pareto" | "RegionMap" | "Treemap" | "Waterfall" | "Sunburst" | "Funnel";

属性值

Excel.ChartType | "Invalid" | "ColumnClustered" | "ColumnStacked" | "ColumnStacked100" | "3DColumnClustered" | "3DColumnStacked" | "3DColumnStacked100" | "BarClustered" | "BarStacked" | "BarStacked100" | "3DBarClustered" | "3DBarStacked" | "3DBarStacked100" | "LineStacked" | "LineStacked100" | "LineMarkers" | "LineMarkersStacked" | "LineMarkersStacked100" | "PieOfPie" | "PieExploded" | "3DPieExploded" | "BarOfPie" | "XYScatterSmooth" | "XYScatterSmoothNoMarkers" | "XYScatterLines" | "XYScatterLinesNoMarkers" | "AreaStacked" | "AreaStacked100" | "3DAreaStacked" | "3DAreaStacked100" | "DoughnutExploded" | "RadarMarkers" | "RadarFilled" | "Surface" | "SurfaceWireframe" | "SurfaceTopView" | "SurfaceTopViewWireframe" | "Bubble" | "Bubble3DEffect" | "StockHLC" | "StockOHLC" | "StockVHLC" | "StockVOHLC" | "CylinderColClustered" | "CylinderColStacked" | "CylinderColStacked100" | "CylinderBarClustered" | "CylinderBarStacked" | "CylinderBarStacked100" | "CylinderCol" | "ConeColClustered" | "ConeColStacked" | "ConeColStacked100" | "ConeBarClustered" | "ConeBarStacked" | "ConeBarStacked100" | "ConeCol" | "PyramidColClustered" | "PyramidColStacked" | "PyramidColStacked100" | "PyramidBarClustered" | "PyramidBarStacked" | "PyramidBarStacked100" | "PyramidCol" | "3DColumn" | "Line" | "3DLine" | "3DPie" | "Pie" | "XYScatter" | "3DArea" | "Area" | "Doughnut" | "Radar" | "Histogram" | "Boxwhisker" | "Pareto" | "RegionMap" | "Treemap" | "Waterfall" | "Sunburst" | "Funnel"

dataLabels

表示系列中所有数据标签的集合。Represents a collection of all dataLabels in the series.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

dataLabels?: Excel.Interfaces.ChartDataLabelsData;

属性值

doughnutHoleSize

表示图表系列的圆环孔大小。Represents the doughnut hole size of a chart series. 仅对圆环图和分离型圆环图有效。Only valid on doughnut and doughnutExploded charts. 对无效图表引发无效参数异常。Throws an invalid argument exception on invalid charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

doughnutHoleSize?: number;

属性值

number

explosion

返回或设置饼图或圆环图切片的分解程度值。Returns or sets the explosion value for a pie-chart or doughnut-chart slice. 如果未分解(切片尖端位于饼图中心),则返回 0(零)。Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie). 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

explosion?: number;

属性值

number

filtered

该布尔值表示是否筛选系列。Boolean value representing if the series is filtered or not. 不适用于曲面图。Not applicable for surface charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

filtered?: boolean;

属性值

boolean

firstSliceAngle

返回或设置第一个饼图或圆环图切片的角度,以度为单位(从垂直方向起为顺时针)。Returns or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). 只适用于饼图、三维饼图和圆环图。Applies only to pie, 3-D pie, and doughnut charts. 可以是 0 到 360 之间的值。Can be a value from 0 through 360. 读/写Read/Write

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

firstSliceAngle?: number;

属性值

number

format

表示图表系列的格式,包括填充和线条格式。Represents the formatting of a chart series, which includes fill and line formatting. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

format?: Excel.Interfaces.ChartSeriesFormatData;

属性值

gapWidth

表示图表系列的间隙宽度。Represents the gap width of a chart series. 仅对条形图和柱形图有效, 以及折线图和饼图的特定类。Only valid on bar and column charts, as well as specific classes of line and pie charts. 对无效图表引发无效参数异常。Throws an invalid argument exception on invalid charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

gapWidth?: number;

属性值

number

gradientMaximumColor

返回或设置区域地图图表系列的最大值的颜色。Returns or sets the color for maximum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMaximumColor?: string;

属性值

string

gradientMaximumType

返回或设置区域地图图表系列的最大值的类型。Returns or sets the type for maximum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMaximumType?: Excel.ChartGradientStyleType | "ExtremeValue" | "Number" | "Percent";

属性值

Excel.ChartGradientStyleType | "ExtremeValue" | "Number" | "Percent"

gradientMaximumValue

返回或设置区域地图图表系列的最大值。Returns or sets the maximum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMaximumValue?: number;

属性值

number

gradientMidpointColor

返回或设置区域地图图表系列的中点值的颜色。Returns or sets the color for midpoint value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMidpointColor?: string;

属性值

string

gradientMidpointType

返回或设置区域地图图表系列的中间值的类型。Returns or sets the type for midpoint value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMidpointType?: Excel.ChartGradientStyleType | "ExtremeValue" | "Number" | "Percent";

属性值

Excel.ChartGradientStyleType | "ExtremeValue" | "Number" | "Percent"

gradientMidpointValue

返回或设置区域地图图表系列的中间值。Returns or sets the midpoint value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMidpointValue?: number;

属性值

number

gradientMinimumColor

返回或设置区域地图图表系列的最小值的颜色。Returns or sets the color for minimum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMinimumColor?: string;

属性值

string

gradientMinimumType

返回或设置区域地图图表系列的最小值的类型。Returns or sets the type for minimum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMinimumType?: Excel.ChartGradientStyleType | "ExtremeValue" | "Number" | "Percent";

属性值

Excel.ChartGradientStyleType | "ExtremeValue" | "Number" | "Percent"

gradientMinimumValue

返回或设置区域地图图表系列的最小值。Returns or sets the minimum value of a region map chart series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientMinimumValue?: number;

属性值

number

gradientStyle

返回或设置区域地图图表的系列渐变样式。Returns or sets series gradient style of a region map chart. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

gradientStyle?: Excel.ChartGradientStyle | "TwoPhaseColor" | "ThreePhaseColor";

属性值

Excel.ChartGradientStyle | "TwoPhaseColor" | "ThreePhaseColor"

hasDataLabels

该布尔值表示系列是否具有数据标签。Boolean value representing if the series has data labels or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

hasDataLabels?: boolean;

属性值

boolean

invertColor

返回或设置系列中负数据点的填充颜色。Returns or sets the fill color for negative data points in a series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

invertColor?: string;

属性值

string

invertIfNegative

如果 Excel 在值为负数时反转项目中的图案,则为 True。True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

invertIfNegative?: boolean;

属性值

boolean

mapOptions

封装区域映射图的选项。Encapsulates the options for a region map chart. 只读。Read-only.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

mapOptions?: Excel.Interfaces.ChartMapOptionsData;

属性值

markerBackgroundColor

表示图表系列的标记背景色。Represents markers background color of a chart series.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

markerBackgroundColor?: string;

属性值

string

markerForegroundColor

表示图表系列的标记前景色。Represents markers foreground color of a chart series.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

markerForegroundColor?: string;

属性值

string

markerSize

表示图表系列的标记大小。Represents marker size of a chart series.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

markerSize?: number;

属性值

number

markerStyle

表示图表系列的标记类型。Represents marker style of a chart series. 有关详细信息, 请参阅 ChartMarkerStyle。See Excel.ChartMarkerStyle for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

markerStyle?: Excel.ChartMarkerStyle | "Invalid" | "Automatic" | "None" | "Square" | "Diamond" | "Triangle" | "X" | "Star" | "Dot" | "Dash" | "Circle" | "Plus" | "Picture";

属性值

Excel.ChartMarkerStyle | "Invalid" | "Automatic" | "None" | "Square" | "Diamond" | "Triangle" | "X" | "Star" | "Dot" | "Dash" | "Circle" | "Plus" | "Picture"

name

表示图表中某个系列的名称。Represents the name of a series in a chart.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

name?: string;

属性值

string

overlap

指定条柱的摆放方式。Specifies how bars and columns are positioned. 可以是–100到100之间的值。Can be a value between –100 and 100. 只适用于二维条形图和二维柱形图。Applies only to 2-D bar and 2-D column charts. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

overlap?: number;

属性值

number

parentLabelStrategy

返回或设置树状图图表的系列父标签策略区域。Returns or sets the series parent label strategy area for a treemap chart. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

parentLabelStrategy?: Excel.ChartParentLabelStrategy | "None" | "Banner" | "Overlapping";

属性值

Excel.ChartParentLabelStrategy | "None" | "Banner" | "Overlapping"

plotOrder

表示图表组中某个图表系列的绘制顺序。Represents the plot order of a chart series within the chart group.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

plotOrder?: number;

属性值

number

points

表示系列中所有数据点的集合。Represents a collection of all points in the series. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

points?: Excel.Interfaces.ChartPointData[];

属性值

Excel.Interfaces.ChartPointData[]

secondPlotSize

返回或设置复合饼图或复合条饼图的辅助分区的大小,以占主饼图大小的百分比表示。Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. 可以是 5 到 200 之间的值。Can be a value from 5 to 200. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

secondPlotSize?: number;

属性值

number

showConnectorLines

指定在瀑布图中是否显示连接符线。Specifies whether or not connector lines are shown in waterfall charts. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

showConnectorLines?: boolean;

属性值

boolean

showLeaderLines

指定是否为系列中的每个数据标签显示引导线。Specifies whether or not leader lines are displayed for each data label in the series. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

showLeaderLines?: boolean;

属性值

boolean

showShadow

表示系列是否具有阴影的布尔值。Boolean value representing if the series has a shadow or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showShadow?: boolean;

属性值

boolean

smooth

该布尔值表示系列是否平滑。Boolean value representing if the series is smooth or not. 仅适用于折线图和散点图。Only applicable to line and scatter charts.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

smooth?: boolean;

属性值

boolean

splitType

返回或设置复合饼图或复合条饼图中两个分区的拆分方式。Returns or sets the way the two sections of either a pie of pie chart or a bar of pie chart are split. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

splitType?: Excel.ChartSplitType | "SplitByPosition" | "SplitByValue" | "SplitByPercentValue" | "SplitByCustomSplit";

属性值

Excel.ChartSplitType | "SplitByPosition" | "SplitByValue" | "SplitByPercentValue" | "SplitByCustomSplit"

splitValue

返回或设置用于分隔复合饼图或复合条饼图的两个节的阈值。Returns or sets the threshold value that separates two sections of either a pie-of-pie chart or a bar-of-pie chart. 读/写。Read/Write.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

splitValue?: number;

属性值

number

trendlines

表示系列中趋势线的集合。Represents a collection of trendlines in the series. 只读。Read-only.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

trendlines?: Excel.Interfaces.ChartTrendlineData[];

属性值

Excel.Interfaces.ChartTrendlineData[]

varyByCategories

如果 Excel 为每个数据标记分配不同的颜色或图案,则为 True。True if Microsoft Excel assigns a different color or pattern to each data marker. 图表必须只包含一个系列。The chart must contain only one series. 读/写。Read/Write.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

varyByCategories?: boolean;

属性值

boolean

xErrorBars

表示图表系列的误差条形图对象。Represents the error bar object of a chart series.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

xErrorBars?: Excel.Interfaces.ChartErrorBarsData;

属性值

yErrorBars

表示图表系列的误差条形图对象。Represents the error bar object of a chart series.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

yErrorBars?: Excel.Interfaces.ChartErrorBarsData;

属性值