Table of Contents

Class ExcelChartEx

Namespace
OfficeOpenXml.Drawing.Chart.ChartEx
Assembly
EPPlus.dll

Base class for all extention charts

public abstract class ExcelChartEx : ExcelChart, IDisposable
Inheritance
ExcelChartEx
Implements
Derived
Inherited Members

Properties

Axis

An array containg all axis of all Charttypes

public ExcelChartExAxis[] Axis { get; }

Property Value

ExcelChartExAxis[]

Border

Border

public override ExcelDrawingBorder Border { get; }

Property Value

ExcelDrawingBorder

DisplayBlanksAs

This property does not apply to extended charts. This property will always return eDisplayBlanksAs.Zero. Setting this property on an extended chart will result in an InvalidOperationException

public override eDisplayBlanksAs DisplayBlanksAs { get; set; }

Property Value

eDisplayBlanksAs

Effect

Effects

public override ExcelDrawingEffectStyle Effect { get; }

Property Value

ExcelDrawingEffectStyle

Fill

Access to Fill properties

public override ExcelDrawingFill Fill { get; }

Property Value

ExcelDrawingFill

Font

Access to font properties

public override ExcelTextFont Font { get; }

Property Value

ExcelTextFont

HasLegend

If the chart has legend or not

public override bool HasLegend { get; }

Property Value

bool

HasTitle

If the chart has a title or not

public override bool HasTitle { get; }

Property Value

bool

Legend

Legend

public ExcelChartExLegend Legend { get; }

Property Value

ExcelChartExLegend

PlotArea

Plotarea properties

public override ExcelChartPlotArea PlotArea { get; }

Property Value

ExcelChartPlotArea

RoundedCorners

This property does not apply to extended charts. Setting this property on an extended chart will result in an InvalidOperationException

public override bool RoundedCorners { get; set; }

Property Value

bool

Series

Chart series

public ExcelChartSeries<ExcelChartExSerie> Series { get; }

Property Value

ExcelChartSeries<ExcelChartExSerie>

ShowDataLabelsOverMaximum

This property does not apply to extended charts. Setting this property on an extended chart will result in an InvalidOperationException

public override bool ShowDataLabelsOverMaximum { get; set; }

Property Value

bool

ShowHiddenData

This property does not apply to extended charts. Setting this property on an extended chart will result in an InvalidOperationException

public override bool ShowHiddenData { get; set; }

Property Value

bool

Style

Cannot be set for extension charts. Please use StyleManager

public override eChartStyle Style { get; set; }

Property Value

eChartStyle

TextBody

Access to text body properties

public override ExcelTextBody TextBody { get; }

Property Value

ExcelTextBody

ThreeD

3D properties

public override ExcelDrawing3D ThreeD { get; }

Property Value

ExcelDrawing3D

Title

The titel of the chart

public ExcelChartExTitle Title { get; }

Property Value

ExcelChartExTitle

VaryColors

Is not applied to Extension charts

public override bool VaryColors { get; set; }

Property Value

bool

View3D

3D settings

public override ExcelView3D View3D { get; }

Property Value

ExcelView3D

XAxis

The X Axis

public ExcelChartExAxis XAxis { get; }

Property Value

ExcelChartExAxis

YAxis

The Y Axis

public ExcelChartExAxis YAxis { get; }

Property Value

ExcelChartExAxis

Methods

DeleteTitle()

Delete the charts title

public override void DeleteTitle()