Overrides the JavaScript toJSON() method in order to provide more useful output when an API object is passed to JSON.stringify(). Positions the chart relative to cells on the worksheet. 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. Get Image(width, height, fitting Mode String) The aspect ratio is preserved as part of the resizing. Renders the chart as a base64-encoded image by scaling the chart to fit the specified dimensions. For further information, see *OrNullObject methods and properties. If the chart doesn't allow a data table, then this method returns an object with its isNullObject property set to true.
If the chart doesn't allow a data table, it will throw an exception. The worksheet containing the current chart. Specifies the width, in points, of the chart object. Specifies the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). Represents the title of the specified chart, including the text, visibility, position, and formatting of the title. This property applies to 2-D charts only.
If the value axis becomes smaller than the size of the data points, you can use this property to set whether to show the data labels. Specifies whether to show the data labels when the value is greater than the maximum value on the value axis. Specifies whether to display all field buttons on a PivotChart.
#FREE EXCEL ADD INS CHARTS SERIES#
Specifies a chart series name level enumeration constant, referring to the level of the source series names. Represents either a single series or collection of series in the chart. False if both visible and hidden cells are plotted. Specifies the way columns or rows are used as data series on the chart. The distance, in points, from the left side of the chart to the worksheet origin.Įncapsulates the options for a pivot chart. Specifies the height, in points, of the chart object. Specifies the way that blank cells are plotted on a chart.Įncapsulates the format properties for the chart area. This connects the add-in's process to the Office host application's process. The request context associated with the object. Specifies a chart category label level enumeration constant, referring to the level of the source category labels.
0 kommentar(er)
