ApiChart
Class representing a chart.
ApiChart is a subclass of ApiDrawing.
Methods
The following table lists the available 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. |
| Copy | ApiChart | Creates a copy of the current chart. |
| Delete | boolean | Deletes the specified drawing object. |
| Fill | boolean | Sets the fill formatting properties to the current graphic object. |
| GetAllSeries | ApiChartSeries[] | Returns all series from the chart space. |
| GetChartType | ChartTypeLegacy | Returns a type of the chart object. |
| GetClassType | "chart" | Returns a type of the ApiChart class. |
| GetDescription | string | null | Gets the description of the current drawing. |
| GetFill | ApiFill | null | Gets the fill formatting properties from the current graphic object. |
| 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. |
| GetInternalId | string | Returns an internal ID of the current drawing object. |
| GetLine | ApiStroke | null | Gets the outline properties from the current graphic object. |
| GetLockAspect | boolean | Returns whether the aspect ratio of the drawing is locked. |
| 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 | null | undefined | Returns the parent sheet of the current drawing. |
| GetPosX | EMU | Returns the x position of the current drawing on the worksheet. |
| GetPosY | EMU | Returns the y position of the current drawing on the worksheet. |
| GetPosition | DrawingCellAnchor | null | Returns the cell anchor of the current drawing; the offsets are limited by the anchor cell. |
| GetRotation | number | Returns the rotation angle of the current drawing object. |
| GetSeries | ApiChartSeries | null | undefined | Returns the series with a specific index. |
| GetShadow | ApiShadow | null | Returns the shadow of the current graphic object. |
| GetTextRange | ApiTextRange | null | Returns a text range that covers the whole text of the current drawing. Creates a text body if the drawing does not yet have one. |
| GetTitle | string | null | Returns the chart title text. |
| GetType | ChartType | Returns a type of the chart object using the chart type names from the {@link ChartType} enumeration. |
| GetWidth | EMU | Returns the width of the current drawing. |
| HasTextContent | boolean | Checks whether the current drawing has a text body. |
| RemoveSeria | boolean | Removes the specified series from the current chart. |
| Select | None | Selects the current graphic object. |
| SetAxisNumFormat | boolean | Sets the specified numeric format to the axis values. |
| SetCatFormula | None | Sets a range with the category values to the current chart. |
| SetDataLabelsTextPr | boolean | Sets the text properties to the chart data labels. |
| 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. |
| SetDescription | boolean | Sets the description of the current drawing. |
| SetFill | boolean | Sets the fill formatting properties to the current graphic object. |
| 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. |
| SetLine | boolean | Sets the outline properties to the current graphic object. |
| SetLockAspect | boolean | Sets whether the aspect ratio of the drawing is locked. |
| 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. |
| 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. |
| SetPointDataLabelTextPr | boolean | Sets the text properties to the chart point data label. |
| SetPosition | None | Changes the position for the drawing object. |
| 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. |
| SetSeriesFill | boolean | Sets the fill to the specified chart series. |
| SetSeriesOutLine | boolean | Sets the outline to the specified chart series. |
| SetShadow | boolean | Sets the shadow to the current graphic object. |
| SetShowDataLabels | boolean | Specifies which chart data labels are shown for the chart. |
| SetShowDataTable | boolean | Specifies whether the data table is displayed below the chart, optionally with the legend keys. |
| 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. |