ig.excel.Series
Dependencies
-
applyPicToEnd
- .applyPicToEnd( );
Apply the picture to the end of the series.
-
applyPicToEnd
- .applyPicToEnd( value:boolean );
Apply the picture to the end of the series.
- value
- Type:boolean
-
applyPicToFront
- .applyPicToFront( );
Apply the picture to the front of the series.
-
applyPicToFront
- .applyPicToFront( value:boolean );
Apply the picture to the front of the series.
- value
- Type:boolean
-
applyPicToSides
- .applyPicToSides( );
Apply the picture to the sides.
-
applyPicToSides
- .applyPicToSides( value:boolean );
Apply the picture to the sides.
- value
- Type:boolean
-
axisGroup
- .axisGroup( );
Specifies what axis group this series applies to.
-
axisGroup
- .axisGroup( value:ig.excel.AxisGroup );
Specifies what axis group this series applies to.
- value
- Type:ig.excel.AxisGroup
-
barShape
- .barShape( );
Determines the shape of the bar for this series. Applicable only for 3D bar charts.
Remarks
This property controls the shape of the bar displayed for this series only.
To set the bar shape for all series in the chart, use the WorksheetChart.barShape property.
See Also
-
barShape
- .barShape( value:ig.excel.BarShape );
Determines the shape of the bar for this series. Applicable only for 3D bar charts.
- value
- Type:ig.excel.BarShape
Remarks
This property controls the shape of the bar displayed for this series only.
To set the bar shape for all series in the chart, use the WorksheetChart.barShape property.
See Also
-
barShapeResolved
- .barShapeResolved( );
Returns the resolved value of the Series.barShape property.
-
border
- .border( );
Determines the appearance of the border drawn around the Series.fill area. Applicable only for chart series which support fills, such as bar charts, area charts, and pie charts.
Remarks
For series which support fills, this property controls the color and size of the line drawn around the fill region.
For line-based series, use the Series.line property.
See Also
-
border
- .border( value:ig.excel.ChartBorder );
Determines the appearance of the border drawn around the Series.fill area. Applicable only for chart series which support fills, such as bar charts, area charts, and pie charts.
- value
- Type:ig.excel.ChartBorder
Remarks
For series which support fills, this property controls the color and size of the line drawn around the fill region.
For line-based series, use the Series.line property.
See Also
-
bubbleSizes
- .bubbleSizes( );
Returns a Series.values instance that determines the bubble sizes in a bubble chart.
-
bubbleSizes
- .bubbleSizes( value:ig.excel.SeriesValues );
Sets a Series.values instance that determines the bubble sizes in a bubble chart.
- value
- Type:ig.excel.SeriesValues
-
chartType
- .chartType( );
Specifies the type of chart for this series
Remarks
Not all chart types are applicable for a given series type; in the case where an invalid chart type is assigned, an exception is thrown.
See Also
-
chartType
- .chartType( value:ig.excel.ChartType );
Specifies the type of chart for this series
- value
- Type:ig.excel.ChartType
Remarks
Not all chart types are applicable for a given series type; in the case where an invalid chart type is assigned, an exception is thrown.
See Also
-
errorBars
- .errorBars( );
Returns an ErrorBars object.
-
errorBars
- .errorBars( value:ig.excel.ErrorBars );
Sets an ErrorBars object.
- value
- Type:ig.excel.ErrorBars
-
explosion
- .explosion( );
Determines the amount of space between slices in a pie or doughnut chart.
-
explosion
- .explosion( value:number );
Determines the amount of space between slices in a pie or doughnut chart.
- value
- Type:number
-
fill
- .fill( );
Returns a ChartFillBase derived object which defines the fill for this series. Not applicable for line charts.
Remarks
This property is not applicable to charts which depict the data series as a line. For these chart types, use the Series.line property, which controls the color and width of the line.
See Also
-
fill
- .fill( value:ig.excel.ChartFillBase );
Sets a ChartFillBase derived object which defines the fill for this series. Not applicable for line charts.
- value
- Type:ig.excel.ChartFillBase
Remarks
This property is not applicable to charts which depict the data series as a line. For these chart types, use the Series.line property, which controls the color and width of the line.
See Also
-
invertIfNegative
- .invertIfNegative( );
Determines if negative values will be inverted.
-
invertIfNegative
- .invertIfNegative( value:boolean );
Determines if negative values will be inverted.
- value
- Type:boolean
-
line
- .line( );
Remarks
This property is not applicable for series which support fills, such as bar, area, or pie charts.
For chart series which supports fills, use the Series.fill property to control the fill color, and the Series.border property for the line drawn around that fill area.
-
line
- .line( value:ig.excel.ChartLine );
Remarks
This property is not applicable for series which support fills, such as bar, area, or pie charts.
For chart series which supports fills, use the Series.fill property to control the fill color, and the Series.border property for the line drawn around that fill area.
-
markerBorder
- .markerBorder( );
Determines the appearance of the border (a.k.a. outline) for the marker.
-
markerBorder
- .markerBorder( value:ig.excel.ChartBorder );
Determines the appearance of the border (a.k.a. outline) for the marker.
- value
- Type:ig.excel.ChartBorder
-
markerFill
- .markerFill( );
Defines the fill appearance for the marker.
-
markerFill
- .markerFill( value:ig.excel.ChartFillBase );
Defines the fill appearance for the marker.
- value
- Type:ig.excel.ChartFillBase
-
markerSize
- .markerSize( );
Determines the size of the markers.
-
markerSize
- .markerSize( value:number );
Determines the size of the markers.
- value
- Type:number
-
markerStyle
- .markerStyle( );
Determines the style of the markers
-
markerStyle
- .markerStyle( value:ig.excel.MarkerStyle );
Determines the style of the markers
- value
- Type:ig.excel.MarkerStyle
-
name
- .name( );
Gets the name of the series
-
name
- .name( value:ig.excel.SeriesName );
Sets the name of the series
- value
- Type:ig.excel.SeriesName
-
pictureType
- .pictureType( );
Determines whether pictures are scaled, stacked, or stretched.
-
pictureType
- .pictureType( value:ig.excel.PictureType );
Determines whether pictures are scaled, stacked, or stretched.
- value
- Type:ig.excel.PictureType
-
pictureUnit
- .pictureUnit( );
Returns a value which defines the unit of measure when Series.pictureType is set to Stack.
-
pictureUnit
- .pictureUnit( value:number );
Sets a value which defines the unit of measure when Series.pictureType is set to Stack.
- value
- Type:number
-
plotOrder
- .plotOrder( );
Gets the plotting order for the data series.
Remarks
Note: this is the order in which the series names will appear in the legend. When there is only one series then this is omitted. This must be a whole number between 1 and the number of series on the chart. If you enter zero then 1 is used. If you enter a number greater than the number of series then the total number of series is used. -
plotOrder
- .plotOrder( value:number );
Sets the plotting order for the data series.
- value
- Type:number
Remarks
Note: this is the order in which the series names will appear in the legend. When there is only one series then this is omitted. This must be a whole number between 1 and the number of series on the chart. If you enter zero then 1 is used. If you enter a number greater than the number of series then the total number of series is used. -
smooth
- .smooth( );
Detewrmines if a smoothing effect should be applied.
-
smooth
- .smooth( value:boolean );
Detewrmines if a smoothing effect should be applied.
- value
- Type:boolean
-
type
- .type( );
Returns a SeriesType value which determines the type of this series.
Remarks
Not all series types are applicable for a given Series.chartType; in the case where an invalid series type is assigned, an exception is thrown.
See Also
-
type
- .type( value:ig.excel.SeriesType );
Sets a SeriesType value which determines the type of this series.
- value
- Type:ig.excel.SeriesType
Remarks
Not all series types are applicable for a given Series.chartType; in the case where an invalid series type is assigned, an exception is thrown.
See Also
-
values
- .values( );
Returns a Series.values instance that contains a collection of all the values in the series.
Remarks
The value of this property can be a range on a worksheet or an array of constant values, but not a combination of both. -
values
- .values( value:ig.excel.SeriesValues );
Sets a Series.values instance that contains a collection of all the values in the series.
- value
- Type:ig.excel.SeriesValues
Remarks
The value of this property can be a range on a worksheet or an array of constant values, but not a combination of both. -
xValues
- .xValues( );
Returns a Series.xValues instance that contains a collection of all the x values in the series.
Remarks
The value of this property can be a range on a worksheet or an array of constant values, but not a combination of both. -
xValues
- .xValues( value:ig.excel.XValues );
Sets a Series.xValues instance that contains a collection of all the x values in the series.
- value
- Type:ig.excel.XValues
Remarks
The value of this property can be a range on a worksheet or an array of constant values, but not a combination of both.