Name | Description | |
---|---|---|

clearFormats | Clears the formatting of the object. | |

delete | Deletes the object. | |

getAxisGroup | Returns the group for the specified chart group or series. | |

getBarShape | Returns or sets the shape used with the 3-D bar or column chart. | |

getBubbleSizes | Gets an array that contains the size data for the bubble chart. Applies only to bubble charts. | |

getChartType | Gets the chart type. | |

getDataLabels | Returns an object that represents a collection of all the data labels for the series. | |

getExplosion | Gets 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). | |

getFormat | Returns the IChartFormat object. | |

getFormula | Gets the object's formula in A1-style notation. | |

getFormulaR1C1 | Gets the formula for the object using R1C1-style notation. | |

getHas3DEffect | Gets whether the series has a three-dimensional appearance. Applies only to bubble charts. | |

getHasDataLabels | Gets whether the series has data labels. | |

getHasErrorBars | Gets whether the series has error bars. This property isn¡¯t available for 3-D charts. | |

getInvertColor | Gets the fill color for negative data points in a series. | |

getInvertIfNegative | Gets whether Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. | |

getMarkerFormat | Returns the IChartFormat for the markers of this series. | |

getMarkerSize | Gets the data-marker size in points. | |

getMarkerStyle | Gets the marker style for a point or series in a line chart, scatter chart, or radar chart. | |

getName | Gets the name of the object. | |

getParent | Returns the parent object for the specified object. | |

getParentDataLabelOption | Gets the parent data label option for the specified series within the chart group. | |

getPictureType | Gets the way pictures are displayed on a column or bar picture chart. | |

getPictureUnit | Gets the unit for each picture on the chart if the PictureType property is set to Scale (if not, this property is ignored). | |

getPlotOrder | Gets the plot order for the selected series within the chart group. | |

getPoints | Returns an object that represents a collection of all the points in the series. | |

getQuartileCalculationInclusiveMedian | Gets whether the median is included in the calculation if N (the number of values in the data) is odd. Valid only for boxwhisker charts. | |

getShowConnectorLines | Gets 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. | |

getShowInnerPoints | Gets whether to show the data points that lie between the lower whisker line and the upper whisker line. Valid only for boxwhisker charts. | |

getShowMeanLine | Gets whether to show the line connecting the means of the boxes in the selected series. Valid only for boxwhisker charts. | |

getShowMeanMarkers | Gets whether to show the mean marker of the selected series. The default value is true. Valid only for boxwhisker charts. | |

getShowOutlierPoints | Gets 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. | |

getSmooth | Gets 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. | |

getTrendlines | Returns an object that represents a collection of all the trendlines for the series. | |

getValues | Gets 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. | |

getXErrorBar | Gets an ErrorBar object that represents the X direction error bar for the series. | |

getXValues | Gets 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. | |

getYErrorBar | Gets an ErrorBar object that represents the Y direction error bar for the series. | |

setAxisGroup | Sets the group for the specified chart group or series. | |

setBarShape | Sets the shape used with the 3-D bar or column chart. | |

setBubbleSizes | Sets an array that contains the size data for the bubble chart. Applies only to bubble charts. | |

setChartType | Sets the chart type. | |

setExplosion | Sets 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). | |

setFormula | Sets the object's formula in A1-style notation. | |

setFormulaR1C1 | Sets the formula for the object using R1C1-style notation. | |

setHas3DEffect | Sets whether the series has a three-dimensional appearance. Applies only to bubble charts. | |

setHasDataLabels | Sets whether the series has data labels. | |

setHasErrorBars | Sets whether the series has error bars. This property isn¡¯t available for 3-D charts. | |

setInvertIfNegative | Sets whether Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. | |

setMarkerSize | Sets the data-marker size in points. | |

setMarkerStyle | Sets the marker style for a point or series in a line chart, scatter chart, or radar chart. | |

setName | Sets the name of the object. | |

setParentDataLabelOption | Sets the parent data label option for the specified series within the chart group. | |

setPictureType | Sets the way pictures are displayed on a column or bar picture chart. | |

setPictureUnit | Sets the unit for each picture on the chart if the PictureType property is set to Scale (if not, this property is ignored). | |

setPlotOrder | Sets the plot order for the selected series within the chart group. | |

setQuartileCalculationInclusiveMedian | Sets whether the median is included in the calculation if N (the number of values in the data) is odd. Valid only for boxwhisker charts. | |

setShowConnectorLines | Sets 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. | |

setShowInnerPoints | Sets whether to show the data points that lie between the lower whisker line and the upper whisker line. Valid only for boxwhisker charts. | |

setShowMeanLine | Sets whether to show the line connecting the means of the boxes in the selected series. Valid only for boxwhisker charts. | |

setShowMeanMarkers | Sets whether to show the mean marker of the selected series. The default value is true. Valid only for boxwhisker charts. | |

setShowOutlierPoints | Sets 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. | |

setSmooth | Sets 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. | |

setValues | Sets 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. | |

setXValues | Sets 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. |