Class ExcelChartPlotArea

Namespace

OfficeOpenXml.Drawing.Chart

Assembly

EPPlus.dll

A charts plot area

public class ExcelChartPlotArea : XmlHelper

Inheritance

object

XmlHelper

ExcelChartPlotArea

Derived

ExcelChartExPlotarea

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

Border

Access to border properties

public ExcelDrawingBorder Border { get; }

Property Value

ExcelDrawingBorder

ChartTypes

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

public ExcelChartCollection ChartTypes { get; }

Property Value

ExcelChartCollection

DataTable

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

public ExcelChartDataTable DataTable { get; }

Property Value

ExcelChartDataTable

Effect

Effects

public ExcelDrawingEffectStyle Effect { get; }

Property Value

ExcelDrawingEffectStyle

Fill

Access to fill properties

public ExcelDrawingFill Fill { get; }

Property Value

ExcelDrawingFill

ThreeD

3D properties

public ExcelDrawing3D ThreeD { get; }

Property Value

ExcelDrawing3D

Methods

CreateDataTable()

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

public virtual ExcelChartDataTable CreateDataTable()

Returns

ExcelChartDataTable

RemoveDataTable()

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

public virtual void RemoveDataTable()