Represents a chart worksheet.
Inheritance Hierarchy
Winnovative.ExcelLibExcelChartWorksheet
Namespace: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax
The ExcelChartWorksheet type exposes the following members.
Properties
Name | Description | |
---|---|---|
![]() | 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.
|
![]() | ChartType |
Gets or sets the chart type
|
![]() | 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.
|
![]() | Legend |
Gets the chart legend.
|
![]() | Name |
Gets or sets the name of chart worksheet.
|
![]() | PageSetup |
Gets the chart worksheet page setup options (paper size, page orientation, etc.).
|
![]() | PlotArea |
Gets the chart plot area. The returned object can be used to set the border and the interior of the chart plot 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.
|
![]() | SheetIndex |
Gets the index of this chart worksheet in the workbook sheets collection.
|
![]() | 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.
|
![]() | ValueAxis |
Gets the value axis of this chart.
|
![]() | Workbook |
Gets the workbook of this chart worksheet.
|
Methods
Name | Description | |
---|---|---|
![]() | Activate |
Makes this chart worksheet the active worksheet of the workbook.
|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | Allows an object to try to free resources and perform other cleanup operations before it 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.) |
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | ToString | Returns a string that represents the current object. (Inherited from Object.) |
See Also