Chart Members
An embedded chart on a worksheet.Properties
| Name | Description |
|---|---|
| AlternativeText | Gets or sets the descriptive (alternative) text for a drawing object. Inherited from Shape. |
| BottomRightCell | Gets or sets a cell where the bottom right corner of a floating object is located. Inherited from FloatingObject. |
| ChartType | Returns the chart type. Inherited from ChartObject. |
| ColorPalette | Returns or specifies a color palette for the chart. Applies only to Excel 2016 charts. Inherited from ChartObject. |
| ConnectorFormat | Provides access to the shape connector settings. Inherited from Shape. |
| DataTable | Provides access to display settings for the chart data table. Inherited from ChartObject. |
| Fill | Provides access to fill options for the specified drawing object. Inherited from ShapeFormatBase. |
| Font | Allows you to change the text font for all chart elements. Inherited from ChartObject. |
| Height | Gets or sets the height of the floating object. Inherited from FloatingObject. |
| Hyperlink | Gets the hyperlink associated with a drawing object (picture). Inherited from Shape. |
| Id | Gets the drawing object identifier. Inherited from Shape. |
| Left | Gets or sets the distance from the left edge of the worksheet to the top left corner of the floating object. Inherited from FloatingObject. |
| Legend | Provides access to a chart legend. Inherited from ChartObject. |
| LockAspectRatio | Gets or sets whether the floating object retains its original proportions after resizing. Inherited from FloatingObject. |
| Name | Gets or sets the name of the drawing object. Inherited from Shape. |
| OffsetX | Gets a distance from the top left corner of the floating to the left edge of the cell where the top left corner of the floating object is located. Inherited from FloatingObject. |
| OffsetY | Gets a distance from the top left corner of the floating object to the top edge of the cell where the top left corner of the floating object is located. Inherited from FloatingObject. |
| Options | Provides access to various options available for the chart. Inherited from ChartObject. |
| Outline | Provides access to the options used to format an outline of the specified drawing object. Inherited from ShapeFormatBase. |
| ParentGroup | Retrieves the group in which the current shape is contained. Inherited from Shape. |
| Placement | Gets or sets the behavior of the floating object regarding the cells below. Inherited from FloatingObject. |
| PlotArea | Provides access to the chart’s plot area. Inherited from ChartObject. |
| PrimaryAxes | Provides access to a collection of primary axes. Inherited from ChartObject. |
| Rotation | Gets or sets the rotation of the drawing object, in degrees. Inherited from Shape. |
| SecondaryAxes | Provides access to a collection of secondary axes. Inherited from ChartObject. |
| Series | Provides access to the collection of Series objects. Inherited from ChartObject. |
| ShapeGeometry | Provides access to the shape’s geometry options. Inherited from Shape. |
| ShapeText | Provides access to the shape’s text options. Inherited from Shape. |
| ShapeType | Returns the type of the drawing object. Inherited from Shape. |
| Style | Returns or specifies the chart style. Inherited from ChartObject. |
| Title | Gets the title of the chart. Inherited from ChartObject. |
| Top | Gets or sets the distance from the top edge of the worksheet to the top left corner of the floating object. Inherited from FloatingObject. |
| TopLeftCell | Gets or sets a cell where the top left corner of a floating object is located. Inherited from FloatingObject. |
| View3D | Provides access to the display settings of three-dimensional charts. Inherited from ChartObject. |
| Views | Returns a collection of chart views. Inherited from ChartObject. |
| Width | Gets or sets the width of the floating object. Inherited from FloatingObject. |
| ZOrderPosition | Gets the position of the current drawing object in the z-order. Inherited from Shape. |
Methods
| Name | Description |
|---|---|
| ChangeType(ChartType) | Changes the type of the chart. Inherited from ChartObject. |
| CopyTo(Worksheet) | Creates a copy of the chart in another worksheet. Inherited from ChartObject. |
| Delete() | Deletes a drawing object. Inherited from Shape. |
| ExportToImage() | Saves the drawing object as an image. Inherited from Shape. |
| ExportToImage(Stream, ImageFileFormat) | Saves the drawing object as an image in the specified format. Inherited from Shape. |
| ExportToImage(String, ImageFileFormat) | Saves the drawing object as an image in the specified format. Inherited from Shape. |
| GetChildren() | Retrieves the list of nested shapes and shape groups. Inherited from Shape. |
| GetDataRange() | Returns a cell range containing chart data. Inherited from ChartObject. |
| GetImage() | Converts the chart to an image. Inherited from ChartObject. |
| GetImage(Size) | Converts the chart to an image of the specified size. Inherited from ChartObject. |
| IncrementRotation(Int32) | Increments the rotation angle of the drawing object by the specified number of degrees. Inherited from Shape. |
| InsertHyperlink(String, Boolean) | Associates a hyperlink with the drawing object. Inherited from Shape. |
| LoadStyle(Stream) | Loads a custom style from the specified stream and applies it to the chart. Available only for Excel 2016 charts. Inherited from ChartObject. |
| LoadStyle(String) | Loads a custom style from the specified XML file and applies it to the chart. Available only for Excel 2016 charts. Inherited from ChartObject. |
| LoadTemplate(Stream) | Loads a custom chart style and formatting settings from the stream and applies it to the chart. Inherited from ChartObject. |
| Move(Single, Single) | Moves a floating object by a specified offset. Inherited from FloatingObject. |
| MoveToNewChartSheet(String) | Moves the current chart to a separate chart sheet. Inherited from ChartObject. |
| MoveToWorksheet(Worksheet) | Moves a chart to the specified worksheet. Inherited from ChartObject. |
| RemoveHyperlink() | Removes the hyperlink associated with the current drawing object. Inherited from Shape. |
| ResetToMatchStyle() | Removes custom formatting of the chart element and applies default formatting based on the chart style. Inherited from ShapeFormat. |
| SelectData(CellRange, ChartDataDirection) | Specifies the source data for the chart. Inherited from ChartObject. |
| SelectData(CellRange) | Specifies the source data for the chart. Inherited from ChartObject. |
| SwitchRowColumn() | Switches rows to columns in the chart data, plotting them on different axes. Inherited from ChartObject. |
See Also