( JSON.stringify, in turn, calls the toJSON method of the object that is passed to it.) Whereas the original Excel.ChartSeries object is an API object, the toJSON method returns a plain JavaScript object (typed as ) that contains shallow copies of any loaded child properties from the original object. Overrides the JavaScript toJSON() method in order to provide more useful output when an API object is passed to JSON.stringify(). Sets the values of the x-axis for a chart series. For scatter charts, it refers to y-axis values. Sets the bubble sizes for a chart series. Sets multiple properties on the object at the same time, based on an existing loaded object. You can pass either a plain object with the appropriate properties, or another API object of the same type. Sets multiple properties of an object at the same time. You must call context.sync() before reading the properties. Queues up a command to load the specified properties of the object. These could be either category values or data values, depending on the dimension specified and how the data is mapped for the chart series. Gets the values from a single dimension of the chart series. Represents the error bar object of a chart series. True if Excel assigns a different color or pattern to each data marker. The collection of trendlines in the series. Specifies the threshold value that separates two sections of either a pie-of-pie chart or a bar-of-pie chart. Specifies the way the two sections of either a pie-of-pie chart or a bar-of-pie chart are split. Only applicable to line and scatter charts. Specifies whether leader lines are displayed for each data label in the series. Specifies whether connector lines are shown in waterfall charts. Specifies 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. Returns a collection of all points in the series.
#Shading regions in a scatter chart excel series
Specifies the plot order of a chart series within the chart group. Specifies the series parent label strategy area for a treemap chart. Applies only to 2-D bar and 2-D column charts. Specifies how bars and columns are positioned. The name's length should not be greater than 255 characters. Specifies the name of a series in a chart. Specifies the marker style of a chart series. Specifies the marker size of a chart series. Specifies the marker foreground color of a chart series. Specifies the marker background color of a chart series. True if Excel inverts the pattern in the item when it corresponds to a negative number.Įncapsulates the options for a region map chart. Specifies the fill color for negative data points in a series. Specifies the series gradient style of a region map chart. Specifies the minimum value of a region map chart series. Specifies the type for the minimum value of a region map chart series. Specifies the color for the minimum value of a region map chart series. Specifies the midpoint value of a region map chart series. Specifies the type for the midpoint value of a region map chart series. Specifies the color for the midpoint value of a region map chart series. Specifies the maximum value of a region map chart series. Specifies the type for maximum value of a region map chart series. Specifies the color for maximum value of a region map chart series. Throws an invalid argument exception on invalid charts. Only valid on bar and column charts, as well as specific classes of line and pie charts. Represents the gap width of a chart series. Represents the formatting of a chart series, which includes fill and line formatting. Applies only to pie, 3-D pie, and doughnut charts. Specifies the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie). Specifies the explosion value for a pie-chart or doughnut-chart slice. Throws an InvalidArgument error on invalid charts. Only valid on doughnut and doughnut exploded charts. Represents the doughnut hole size of a chart series. Represents a collection of all data labels in the series. This connects the add-in's process to the Office host application's process. The request context associated with the object. This property only applies to bubble charts. This can be an integer value from 0 (zero) to 300, representing the percentage of the default size. Specifies the group for the specified series.Įncapsulates the bin options for histogram charts and pareto charts.Įncapsulates the options for the box and whisker charts.