Class ExcelChartEx¶

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

Base class for all extention charts

public abstract class ExcelChartEx : ExcelChart, IDisposable

Inheritance¶

object ← XmlHelper ← ExcelDrawing ← ExcelChart ← ExcelChartEx

Derived¶

ExcelBoxWhiskerChart
ExcelFunnelChart
ExcelHistogramChart
ExcelRegionMapChart
ExcelSunburstChart
ExcelTreemapChart
ExcelWaterfallChart

Implements¶

IDisposable

Inherited Members¶

ExcelChart._chartNode
ExcelChart._chartXmlHelper
ExcelChart.Axis
ExcelChart.BackWall
ExcelChart.Border
ExcelChart.ChartType
ExcelChart.ChartXml
ExcelChart.DeleteTitle()
ExcelChart.DisplayBlanksAs
ExcelChart.DrawingType
ExcelChart.Effect
ExcelChart.Fill
ExcelChart.Floor
ExcelChart.Font
ExcelChart.HasLegend
ExcelChart.HasThirdAxis()
ExcelChart.HasTitle
ExcelChart.IsType3D()
ExcelChart.IsTypeArea()
ExcelChart.IsTypeBubble()
ExcelChart.IsTypeClustered()
ExcelChart.IsTypeDoughnut()
ExcelChart.IsTypeLine()
ExcelChart.IsTypePercentStacked()
ExcelChart.IsTypePie()
ExcelChart.IsTypePieDoughnut()
ExcelChart.IsTypeRadar()
ExcelChart.IsTypeScatter()
ExcelChart.IsTypeShape()
ExcelChart.IsTypeStacked()
ExcelChart.IsTypeStock()
ExcelChart.IsTypeSurface()
ExcelChart.Legend
ExcelChart.PivotTableSource
ExcelChart.PlotArea
ExcelChart.RoundedCorners
ExcelChart.Series
ExcelChart.ShowDataLabelsOverMaximum
ExcelChart.ShowHiddenData
ExcelChart.SideWall
ExcelChart.Style
ExcelChart.StyleManager
ExcelChart.TextBody
ExcelChart.ThreeD
ExcelChart.Title
ExcelChart.UseSecondaryAxis
ExcelChart.VaryColors
ExcelChart.View3D
ExcelChart.WorkSheet
ExcelChart.XAxis
ExcelChart.YAxis
ExcelDrawing.AdjustPositionAndSize()
ExcelDrawing.As
ExcelDrawing.BringToFront()
ExcelDrawing.CellAnchor
ExcelDrawing.ChangeCellAnchor(eEditAs, int, int, int, int)
ExcelDrawing.ChangeCellAnchor(eEditAs)
ExcelDrawing.Copy(ExcelChartStandard, int, int)
ExcelDrawing.Copy(ExcelWorksheet, int, int, int, int)
ExcelDrawing.Description
ExcelDrawing.Dispose()
ExcelDrawing.DrawingType
ExcelDrawing.EditAs
ExcelDrawing.EMU_PER_CM
ExcelDrawing.EMU_PER_MM
ExcelDrawing.EMU_PER_PICA
ExcelDrawing.EMU_PER_PIXEL
ExcelDrawing.EMU_PER_POINT
ExcelDrawing.EMU_PER_US_INCH
ExcelDrawing.From
ExcelDrawing.Group(params ExcelDrawing[])
ExcelDrawing.Hyperlink
ExcelDrawing.Locked
ExcelDrawing.Name
ExcelDrawing.ParentGroup
ExcelDrawing.Position
ExcelDrawing.Print
ExcelDrawing.SendToBack()
ExcelDrawing.SetPosition(int, int, int, int)
ExcelDrawing.SetPosition(int, int)
ExcelDrawing.SetSize(int, int)
ExcelDrawing.SetSize(int)
ExcelDrawing.Size
ExcelDrawing.To
ExcelDrawing.UnGroup(bool)
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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()