Class ExcelChartPlotArea

A charts plot area

Inheritance

System.Object

XmlHelper

ExcelChartPlotArea

ExcelChartExPlotarea

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Drawing.Chart

Assembly: EPPlus.dll

Syntax

public class ExcelChartPlotArea : XmlHelper

Properties

Border

Access to border properties

Declaration

public ExcelDrawingBorder Border { get; }

Property Value

Type	Description
ExcelDrawingBorder

ChartTypes

If a chart contains multiple chart types (e.g lineChart,BarChart), they end up here.

Declaration

public ExcelChartCollection ChartTypes { get; }

Property Value

Type	Description
ExcelChartCollection

DataTable

The data table object. Use the CreateDataTable method to create a datatable if it does not exist. CreateDataTable() RemoveDataTable()

Declaration

public ExcelChartDataTable DataTable { get; }

Property Value

Type	Description
ExcelChartDataTable

Effect

Effects

Declaration

public ExcelDrawingEffectStyle Effect { get; }

Property Value

Type	Description
ExcelDrawingEffectStyle

Fill

Access to fill properties

Declaration

public ExcelDrawingFill Fill { get; }

Property Value

Type	Description
ExcelDrawingFill

ThreeD

3D properties

Declaration

public ExcelDrawing3D ThreeD { get; }

Property Value

Type	Description
ExcelDrawing3D

Methods

CreateDataTable()

Creates a data table in the plotarea The datatable can also be accessed via the DataTable propery DataTable

Declaration

public virtual ExcelChartDataTable CreateDataTable()

Returns

Type	Description
ExcelChartDataTable

RemoveDataTable()

Remove the data table if it's created in the plotarea

Declaration

public virtual void RemoveDataTable()