ApiChart
ApiChart is a subclass of ApiDrawing.
Methods
| Method | Returns | Description |
|---|---|---|
| AddSeria | None | Adds a new series to the current chart. |
| ApplyChartStyle | boolean | Sets a style to the current chart by style ID. |
| Fill | boolean | Sets the fill formatting properties to the current graphic object. |
| GetAllSeries | ApiChartSeries[] | Returns all series from the chart space. |
| GetChartType | ChartType | Returns a type of the chart object. |
| GetClassType | "chart" | Returns a type of the ApiChart class. |
| GetFlipH | boolean | null | Get horizontal flip of current drawing. |
| GetFlipV | boolean | null | Get vertical flip of current drawing. |
| GetHeight | EMU | Returns the height of the current drawing. |
| GetLockValue | boolean | Returns the lock value for the specified lock type of the current drawing. |
| GetName | string | Returns the name of the current drawing. |
| GetParentSheet | ApiWorksheet | Returns the parent sheet of the current drawing. |
| GetRotation | number | Returns the rotation angle of the current drawing object. |
| GetSeries | ApiChartSeries | Returns the series with a specific index. |
| GetTitle | string | null | Returns the chart title text. |
| GetWidth | EMU | Returns the width of the current drawing. |
| RemoveSeria | boolean | Removes the specified series from the current chart. |
| Select | None | Selects the current graphic object. |
| SetAxieNumFormat | boolean | Sets the specified numeric format to the axis values. |
| SetCatFormula | None | Sets a range with the category values to the current chart. |
| SetDataPointFill | boolean | Sets the fill to the data point in the specified chart series. |
| SetDataPointOutLine | boolean | Sets the outline to the data point in the specified chart series. |
| SetFlipH | boolean | Sets the horizontal flip of the current drawing. |
| SetFlipV | boolean | Sets the vertical flip of the current drawing. |
| SetHorAxisLabelsFontSize | boolean | Specifies font size for labels of the horizontal axis. |
| SetHorAxisMajorTickMark | boolean | Specifies major tick mark for the horizontal axis. |
| SetHorAxisMinorTickMark | boolean | Specifies minor tick mark for the horizontal axis. |
| SetHorAxisOrientation | boolean | Specifies the horizontal axis orientation. |
| SetHorAxisTickLabelPosition | boolean | Spicifies tick labels position for the horizontal axis. |
| SetHorAxisTitle | boolean | Specifies the chart horizontal axis title. |
| SetLegendFill | boolean | Sets the fill to the chart legend. |
| SetLegendFontSize | boolean | Specifies the legend font size. |
| SetLegendOutLine | boolean | Sets the outline to the chart legend. |
| SetLegendPos | boolean | Specifies the chart legend position. |
| SetLockValue | boolean | Sets the lock value to the specified lock type of the current drawing. |
| SetMajorHorizontalGridlines | boolean | Specifies major horizontal gridline visual properties. |
| SetMajorVerticalGridlines | boolean | Specifies major vertical gridline visual properties. |
| SetMarkerFill | boolean | Sets the fill to the marker in the specified chart series. |
| SetMarkerOutLine | boolean | Sets the outline to the marker in the specified chart series. |
| SetMinorHorizontalGridlines | boolean | Specifies minor horizontal gridline visual properties. |
| SetMinorVerticalGridlines | boolean | Specifies minor vertical gridline visual properties. |
| SetName | boolean | Sets the name of the current drawing. If another drawing with the same name already exists, that drawing's name will be reset to a default auto-generated name. |
| SetOutLine | boolean | Sets the outline properties to the specified graphic object. |
| SetPlotAreaFill | boolean | Sets the fill to the chart plot area. |
| SetPlotAreaOutLine | boolean | Sets the outline to the chart plot area. |
| SetPosition | None | Changes the position for the drawing object. 💡 Please note that the horizontal and vertical offsets are calculated within the limits of the specified column and row cells only. If this value exceeds the cell width or height, another vertical/horizontal position will be set. |
| SetRotation | boolean | Sets the rotation angle to the current drawing object. |
| SetSeriaName | boolean | Sets a name to the specified series. |
| SetSeriaValues | boolean | Sets values from the specified range to the specified series. |
| SetSeriaXValues | boolean | Sets the x-axis values from the specified range to the specified series. It is used with the scatter charts only. |
| SetSeriesFill | boolean | Sets the fill to the specified chart series. |
| SetSeriesOutLine | boolean | Sets the outline to the specified chart series. |
| SetShowDataLabels | boolean | Specifies which chart data labels are shown for the chart. |
| SetShowPointDataLabel | boolean | Spicifies the show options for data labels. |
| SetSize | None | Sets a size of the object (image, shape, chart) bounding box. |
| SetTitle | boolean | Specifies the chart title. |
| SetTitleFill | boolean | Sets the fill to the chart title. |
| SetTitleOutLine | boolean | Sets the outline to the chart title. |
| SetVerAxisOrientation | boolean | Specifies the vertical axis orientation. |
| SetVerAxisTitle | boolean | Specifies the chart vertical axis title. |
| SetVertAxisLabelsFontSize | boolean | Specifies font size for labels of the vertical axis. |
| SetVertAxisMajorTickMark | boolean | Specifies major tick mark for the vertical axis. |
| SetVertAxisMinorTickMark | boolean | Specifies minor tick mark for the vertical axis. |
| SetVertAxisTickLabelPosition | boolean | Spicifies tick labels position for the vertical axis. |
| Unselect | boolean | Removes the current drawing from the selection. |