Skip to content

Class ExcelChartErrorBars

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

The title of a chart

public class ExcelChartErrorBars : XmlHelper

Inheritance

object ← XmlHelper ← ExcelChartErrorBars

Inherited Members

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties

BarType

The ways to draw an error bar

public eErrorBarType BarType { get; set; }

Property Value

eErrorBarType

Border

Border style

public ExcelDrawingBorder Border { get; }

Property Value

ExcelDrawingBorder

Direction

The directions for the error bars. For scatter-, bubble- and area charts this property can't be changed. Please use the ErrorBars property for Y direction and ErrorBarsX for the X direction.

public eErrorBarDirection Direction { get; set; }

Property Value

eErrorBarDirection

Effect

Effects

public ExcelDrawingEffectStyle Effect { get; }

Property Value

ExcelDrawingEffectStyle

Fill

Fill style

public ExcelDrawingFill Fill { get; }

Property Value

ExcelDrawingFill

Minus

Numeric Source for minus errorbars when ValueType is set to Custom

public ExcelChartNumericSource Minus { get; }

Property Value

ExcelChartNumericSource

NoEndCap

If true, no end cap is drawn on the error bars

public bool NoEndCap { get; set; }

Property Value

bool

Plus

Numeric Source for plus errorbars when ValueType is set to Custom

public ExcelChartNumericSource Plus { get; }

Property Value

ExcelChartNumericSource

ThreeD

3D properties

public ExcelDrawing3D ThreeD { get; }

Property Value

ExcelDrawing3D

Value

The value which used to determine the length of the error bars when ValueType is FixedValue

public double? Value { get; set; }

Property Value

double?

ValueType

The ways to determine the length of the error bars

public eErrorValueType ValueType { get; set; }

Property Value

eErrorValueType

Methods

Remove()

Remove the error bars

public void Remove()