Class ExcelStandardChartWithLines¶

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

Base class for standard charts with line properties.

public abstract class ExcelStandardChartWithLines : ExcelChartStandard, IDisposable, IDrawingDataLabel

Inheritance¶

object ← XmlHelper ← ExcelDrawing ← ExcelChart ← ExcelChartStandard ← ExcelStandardChartWithLines

Derived¶

ExcelLineChart
ExcelStockChart

Implements¶

IDisposable
IDrawingDataLabel

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
ExcelChartStandard.Axis
ExcelChartStandard.Border
ExcelChartStandard.DeleteTitle()
ExcelChartStandard.DisplayBlanksAs
ExcelChartStandard.Effect
ExcelChartStandard.Fill
ExcelChartStandard.Font
ExcelChartStandard.GetChartNodeText()
ExcelChartStandard.Grouping
ExcelChartStandard.HasLegend
ExcelChartStandard.HasTitle
ExcelChartStandard.Legend
ExcelChartStandard.PlotArea
ExcelChartStandard.RoundedCorners
ExcelChartStandard.ShowDataLabelsOverMaximum
ExcelChartStandard.ShowHiddenData
ExcelChartStandard.Style
ExcelChartStandard.TextBody
ExcelChartStandard.ThreeD
ExcelChartStandard.Title
ExcelChartStandard.VaryColors
ExcelChartStandard.View3D
ExcelChartStandard.XAxis
ExcelChartStandard.YAxis
ExcelDrawing.AdjustPositionAndSize()
ExcelDrawing.As
ExcelDrawing.BringToFront()
ExcelDrawing.CellAnchor
ExcelDrawing.ChangeCellAnchor(eEditAs, int, int, int, int)
ExcelDrawing.ChangeCellAnchor(eEditAs)
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¶

DataLabel¶

Access to datalabel properties

public ExcelChartDataLabel DataLabel { get; }

Property Value¶

ExcelChartDataLabel

DownBar¶

Format the down bars on the chart

public ExcelChartStyleItem DownBar { get; }

Property Value¶

ExcelChartStyleItem

DropLine¶

Format the drop lines for the series.

public ExcelChartStyleItem DropLine { get; }

Property Value¶

ExcelChartStyleItem

HasDataLabel¶

If the chart has datalabel

public bool HasDataLabel { get; }

Property Value¶

bool

HighLowLine¶

Format the high-low lines for the series.

public ExcelChartStyleItem HighLowLine { get; }

Property Value¶

ExcelChartStyleItem

Marker¶

If the series has markers

public bool Marker { get; set; }

Property Value¶

bool

Series¶

The series for the chart

public ExcelChartSeries<ExcelLineChartSerie> Series { get; }

Property Value¶

ExcelChartSeries<ExcelLineChartSerie>

Smooth¶

If the series has smooth lines

public bool Smooth { get; set; }

Property Value¶

bool

UpBar¶

Format the up bars on the chart

public ExcelChartStyleItem UpBar { get; }

Property Value¶

ExcelChartStyleItem

UpDownBarGapWidth¶

The gap width between the up and down bars

public double? UpDownBarGapWidth { get; set; }

Property Value¶

double?

Methods¶

AddDropLines()¶

Adds droplines to the chart.

public ExcelChartStyleItem AddDropLines()

Returns¶

ExcelChartStyleItem

AddHighLowLines()¶

Adds High-Low lines to the chart.

public ExcelChartStyleItem AddHighLowLines()

Returns¶

ExcelChartStyleItem

AddUpDownBars(bool, bool)¶

Adds up and/or down bars to the chart.

public void AddUpDownBars(bool upBars = true, bool downBars = true)

Parameters¶

upBars bool

Adds up bars if up bars does not exist.

downBars bool

Adds down bars if down bars does not exist.