Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel.drawing Package / ISeries Interface

In This Topic
    ISeries Interface Methods
    In This Topic

    For a list of all members of this type, see ISeries members.

    Public Methods
     NameDescription
     MethodClears the formatting of the object.  
     MethodDeletes the object.  
     MethodReturns the group for the specified chart group or series.  
     MethodReturns or sets the shape used with the 3-D bar or column chart.  
     MethodGets an array that contains the size data for the bubble chart. Applies only to bubble charts.  
     MethodGets the chart type.  
     MethodReturns an object that represents a collection of all the data labels for the series.  
     MethodGets the explosion value for a pie-chart or doughnut-chart slice. Returns 0 (zero) if there is no explosion (the tip of the slice is in the center of the pie).  
     MethodReturns the IChartFormat object.  
     MethodGets the object's formula in A1-style notation.  
     MethodGets the formula for the object using R1C1-style notation.  
     MethodGets whether the series has a three-dimensional appearance. Applies only to bubble charts.  
     MethodGets whether the series has data labels.  
     MethodGets whether the series has error bars. This property isní»t available for 3-D charts.  
     MethodGets the fill color for negative data points in a series.  
     MethodGets whether Microsoft Excel inverts the pattern in the item when it corresponds to a negative number.  
     MethodReturns the IChartFormat for the markers of this series.  
     MethodGets the data-marker size in points.  
     MethodGets the marker style for a point or series in a line chart, scatter chart, or radar chart.  
     MethodGets the name of the object.  
     MethodReturns the parent object for the specified object.  
     MethodGets the parent data label option for the specified series within the chart group.  
     MethodGets the way pictures are displayed on a column or bar picture chart.  
     MethodGets the unit for each picture on the chart if the PictureType property is set to Scale (if not, this property is ignored).  
     MethodGets the plot order for the selected series within the chart group.  
     MethodReturns an object that represents a collection of all the points in the series.  
     MethodGets whether the median is included in the calculation if N (the number of values in the data) is odd. Valid only for boxwhisker charts.  
     MethodGets whether to show the connector lines which connect the end of each column to the beginning of the next column. The default value is true. Valid only for waterfall charts.  
     MethodGets whether to show the data points that lie between the lower whisker line and the upper whisker line. Valid only for boxwhisker charts.  
     MethodGets whether to show the line connecting the means of the boxes in the selected series. Valid only for boxwhisker charts.  
     MethodGets whether to show the mean marker of the selected series. The default value is true. Valid only for boxwhisker charts.  
     MethodGets whether to show the outlier points that lie either below the lower whisker line or above the upper whisker line. The default value is true. Valid only for boxwhisker charts.  
     MethodGets the curve smoothing setting (True if curve smoothing is turned on for the line chart or scatter chart). Applies only to line and scatter charts.  
     MethodReturns an object that represents a collection of all the trendlines for the series.  
     MethodGets a collection of all the values in the series. This can come from a range on a worksheet or an array of constant values, but not a combination of both.  
     MethodGets an ErrorBar object that represents the X direction error bar for the series.  
     MethodGets an array of x values for a chart series. The XValues property can come from a range on a worksheet or an array of values, but it cannot be a combination of both.  
     MethodGets an ErrorBar object that represents the Y direction error bar for the series.  
     MethodSets the group for the specified chart group or series.  
     MethodSets the shape used with the 3-D bar or column chart.  
     MethodSets an array that contains the size data for the bubble chart. Applies only to bubble charts.  
     MethodSets the chart type.  
     MethodSets the explosion value for a pie-chart or doughnut-chart slice. Returns 0 (zero) if there is no explosion (the tip of the slice is in the center of the pie).  
     MethodSets the object's formula in A1-style notation.  
     MethodSets the formula for the object using R1C1-style notation.  
     MethodSets whether the series has a three-dimensional appearance. Applies only to bubble charts.  
     MethodSets whether the series has data labels.  
     MethodSets whether the series has error bars. This property isní»t available for 3-D charts.  
     MethodSets whether Microsoft Excel inverts the pattern in the item when it corresponds to a negative number.  
     MethodSets the data-marker size in points.  
     MethodSets the marker style for a point or series in a line chart, scatter chart, or radar chart.  
     MethodSets the name of the object.  
     MethodSets the parent data label option for the specified series within the chart group.  
     MethodSets the way pictures are displayed on a column or bar picture chart.  
     MethodSets the unit for each picture on the chart if the PictureType property is set to Scale (if not, this property is ignored).  
     MethodSets the plot order for the selected series within the chart group.  
     MethodSets whether the median is included in the calculation if N (the number of values in the data) is odd. Valid only for boxwhisker charts.  
     MethodSets whether to show the connector lines which connect the end of each column to the beginning of the next column. The default value is true. Valid only for waterfall charts.  
     MethodSets whether to show the data points that lie between the lower whisker line and the upper whisker line. Valid only for boxwhisker charts.  
     MethodSets whether to show the line connecting the means of the boxes in the selected series. Valid only for boxwhisker charts.  
     MethodSets whether to show the mean marker of the selected series. The default value is true. Valid only for boxwhisker charts.  
     MethodSets whether to show the outlier points that lie either below the lower whisker line or above the upper whisker line. The default value is true. Valid only for boxwhisker charts.  
     MethodSets the curve smoothing setting (True if curve smoothing is turned on for the line chart or scatter chart). Applies only to line and scatter charts.  
     MethodSets a collection of all the values in the series. This can come from a range on a worksheet or an array of constant values, but not a combination of both.  
     MethodSets an array of x values for a chart series. The XValues property can come from a range on a worksheet or an array of values, but it cannot be a combination of both.  
    Top
    See Also