ExpertXls Excel Library for .NET
ExcelChart Class
Namespaces ► ExpertXls.ExcelLib ► ExcelChart
ExpertXls Excel Library for .NET
Represents a chart shape in a worksheet.
Declaration Syntax

C# | Visual Basic | Visual C++

    public class ExcelChart

    Public Class ExcelChart

    public ref class ExcelChart

Members

All Members | Methods | Properties
Public Protected | Instance Static | Declared Inherited

Icon | Member | Description
--- | --- | ---
| BottomRowIndex | Gets or sets the one based bottom row index of the chart area in the worksheet. The bottom row is not included in the chart area.
| CategoryAxis | Gets the category axis of this chart.
| ChartArea | Gets the chart area. The returned object can be used to set the border and the interior of the chart area.
| ChartHeightPoints | Gets or sets the height in points (1 point is 1/72 inch) of the chart area. The bottom row index is adjusted based on the specified height.
| ChartHeightPx | Gets or sets the height in pixels (1 pixels is 1/96 inch) of the chart area. The bottom row index is adjusted based on the specified height. The height is measured in pixels. The dimensions can be converted from pixels to inches using the UnitsConverter class.
| ChartLeftPositionPoints | Gets or sets the position in points (1 point is 1/72 inch) of the the left edge of the chart area inside the worksheet. The left and right column indexes are adjusted based on the specified left position to keep the width.
| ChartLeftPositionPx | Gets or sets the position in pixels (1 pixels is 1/96 inch) of the the left edge of the chart area inside the worksheet. The left and right column indexes are adjusted based on the specified left position to keep the width. The left position is measured in pixels. The dimensions can be converted from pixels to inches using the UnitsConverter class.
| ChartTopPositionPoints | Gets or sets the position in points (1 point is 1/72 inch) of the the top edge of the chart area inside the worksheet. The top and bottom column indexes are adjusted based on the specified top position to keep the height.
| ChartTopPositionPx | Gets or sets the position in pixels (1 pixels is 1/96 inch) of the the top edge of the chart area inside the worksheet. The top and bottom column indexes are adjusted based on the specified top position to keep the height. The top position is measured in pixels. The dimensions can be converted from pixels to inches using the UnitsConverter class.
| ChartType | Gets or sets the chart type
| ChartWidthPoints | Gets or sets the chart area width in points (1 point is 1/72 inch). The right column index is adjusted based on the specified width.
| ChartWidthPx | Gets or sets the width in pixels (1 pixels is 1/96 inch) of the chart area. The right column index is adjusted based on the specified width. The width is measured in pixels. The dimensions can be converted from pixels to inches using the UnitsConverter class.
| DataSourceRange | Gets or sets the data source range of the chart
| DataTable | Gets an object that can be used to set the chart data table options.
| Equals(Object) | Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
| Finalize()()() | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
| GetHashCode()()() | Serves as a hash function for a particular type. (Inherited from Object.)
| GetType()()() | Gets the Type of the current instance. (Inherited from Object.)
| LeftColumnIndex | Gets or sets the one based left column index of the chart area in the worksheet. The left column is included in the chart area.
| Legend | Gets the chart legend.
| MemberwiseClone()()() | Creates a shallow copy of the current Object. (Inherited from Object.)
| PlotArea | Gets the chart plot area. The returned object can be used to set the border and the interior of the chart plot area.
| RightColumnIndex | Gets or sets the one based right column index of the chart area in the worksheet. The right column is not included in the chart area.
| Rotation3D | Gets the 3D chart rotation properties. The returned object can be used to set the X and Y axes rotation, perspective, depth and height of a 3D chart.
| Series | Gets the data series collection of this chart.
| SeriesAxis | Gets the series axis of this chart.
| SeriesByRows | Gets or sets a flag indicating if the chart series are created from the data source range rows or columns. The data source range can be specified when the chart is added to the worksheet. When this flag is true the series are created from rows otherwise from columns.
| ShowDataTable | Gets or sets a flag indicating if the chart data table is displayed.
| Title | Gets the chart title box. The returned object can be used to set the chart title text, font, color, background and pattern.
| TopRowIndex | Gets or sets the one based top row index of the chart area in the worksheet. The top row is included in the chart area.
| ToString()()() | Returns a String that represents the current Object. (Inherited from Object.)
| ValueAxis | Gets the value axis of this chart.
| Worksheet | Gets the worksheet of this chart.

Inheritance Hierarchy

Object
| ExcelChart

Assembly: ExpertXls.ExcelLib (Module: ExpertXls.ExcelLib) Version: 2.1.0.0 (2.1.0.0)