ExcelChartWorksheet Class

Represents a chart worksheet.

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 11.0.0
C#
public class ExcelChartWorksheet
Inheritance
Object    ExcelChartWorksheet

Properties

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

Activate Makes this chart worksheet the active worksheet of the workbook.
Equals
(Inherited from Object)
Finalize
(Inherited from Object)
GetHashCode
(Inherited from Object)
GetType
(Inherited from Object)
MemberwiseClone
(Inherited from Object)
ToString
(Inherited from Object)

See Also