Class ExcelChart

Base class for Chart object.

Inheritance
System.Object
XmlHelper
ExcelDrawing
ExcelChart
ExcelBarChart
ExcelLineChart
ExcelPieChart
ExcelScatterChart
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Experior.Core.Data.OfficeOpenXml.Drawing.Chart
Assembly: Experior.Core.dll
Syntax
public class ExcelChart : ExcelDrawing

Fields

_chartXmlHelper

Declaration
protected XmlHelper _chartXmlHelper
Field Value
Type Description
XmlHelper

Properties

Axis

An array containg all axis of all Charttypes

Declaration
public ExcelChartAxis[] Axis { get; }
Property Value
Type Description
ExcelChartAxis[]

Border

Border

Declaration
public ExcelDrawingBorder Border { get; }
Property Value
Type Description
ExcelDrawingBorder

ChartType

Type of chart

Declaration
public eChartType ChartType { get; }
Property Value
Type Description
eChartType

ChartXml

The chart xml document

Declaration
public XmlDocument ChartXml { get; }
Property Value
Type Description
System.Xml.XmlDocument

DisplayBlanksAs

Specifies the possible ways to display blanks

Declaration
public eDisplayBlanksAs DisplayBlanksAs { get; set; }
Property Value
Type Description
eDisplayBlanksAs

Fill

Fill

Declaration
public ExcelDrawingFill Fill { get; }
Property Value
Type Description
ExcelDrawingFill

Grouping

Declaration
public eGrouping Grouping { get; }
Property Value
Type Description
eGrouping

Legend

Legend

Declaration
public ExcelChartLegend Legend { get; }
Property Value
Type Description
ExcelChartLegend

PivotTableSource

Declaration
public ExcelPivotTable PivotTableSource { get; }
Property Value
Type Description
ExcelPivotTable

PlotArea

Plotarea

Declaration
public ExcelChartPlotArea PlotArea { get; }
Property Value
Type Description
ExcelChartPlotArea

Series

Chart series

Declaration
public ExcelChartSeries Series { get; }
Property Value
Type Description
ExcelChartSeries

ShowHiddenData

Show data in hidden rows and columns

Declaration
public bool ShowHiddenData { get; set; }
Property Value
Type Description
System.Boolean

Style

The build-in chart styles.

Declaration
public eChartStyle Style { get; set; }
Property Value
Type Description
eChartStyle

Title

Titel of the chart

Declaration
public ExcelChartTitle Title { get; }
Property Value
Type Description
ExcelChartTitle

UseSecondaryAxis

If true the charttype will use the secondary axis. The chart must contain a least one other charttype that uses the primary axis.

Declaration
public bool UseSecondaryAxis { get; set; }
Property Value
Type Description
System.Boolean

VaryColors

If the chart has only one serie this varies the colors for each point.

Declaration
public bool VaryColors { get; set; }
Property Value
Type Description
System.Boolean

View3D

3D-settings

Declaration
public ExcelView3D View3D { get; }
Property Value
Type Description
ExcelView3D

WorkSheet

Reference to the worksheet

Declaration
public ExcelWorksheet WorkSheet { get; }
Property Value
Type Description
ExcelWorksheet

XAxis

The XAxis

Declaration
public ExcelChartAxis XAxis { get; }
Property Value
Type Description
ExcelChartAxis

YAxis

The YAxis

Declaration
public ExcelChartAxis YAxis { get; }
Property Value
Type Description
ExcelChartAxis

Methods

GetChartNodeText()

Get the name of the chart node

Declaration
protected string GetChartNodeText()
Returns
Type Description
System.String

The name

IsType3D()

Declaration
protected bool IsType3D()
Returns
Type Description
System.Boolean

IsTypeClustered()

Declaration
protected bool IsTypeClustered()
Returns
Type Description
System.Boolean

IsTypeLine()

Declaration
protected bool IsTypeLine()
Returns
Type Description
System.Boolean

IsTypePercentStacked()

Declaration
protected bool IsTypePercentStacked()
Returns
Type Description
System.Boolean

IsTypePieDoughnut()

Declaration
protected bool IsTypePieDoughnut()
Returns
Type Description
System.Boolean

IsTypeScatter()

Declaration
protected bool IsTypeScatter()
Returns
Type Description
System.Boolean

IsTypeShape()

Declaration
protected bool IsTypeShape()
Returns
Type Description
System.Boolean

IsTypeStacked()

Declaration
protected bool IsTypeStacked()
Returns
Type Description
System.Boolean