Class ExcelBarChart¶

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

Represents a Bar Chart

public sealed class ExcelBarChart : ExcelChartStandard, IDisposable, IDrawingDataLabel

Inheritance¶

object ← XmlHelper ← ExcelDrawing ← ExcelChart ← ExcelChartStandard ← ExcelBarChart

Implements¶

IDisposable
IDrawingDataLabel

Inherited Members¶

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.HasTitle
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.Drawings
ExcelChartStandard.Effect
ExcelChartStandard.Fill
ExcelChartStandard.Font
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(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.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

DataLabel¶

Access to datalabel properties

public ExcelChartDataLabel DataLabel { get; }

Property Value¶

ExcelChartDataLabel

Direction¶

Direction, Bar or columns

public eDirection Direction { get; }

Property Value¶

eDirection

GapWidth¶

The size of the gap between two adjacent bars/columns

public int GapWidth { get; set; }

Property Value¶

int

HasDataLabel¶

If the chart has datalabel

public bool HasDataLabel { get; }

Property Value¶

bool

Overlap¶

Specifies how much bars and columns shall overlap

public int Overlap { get; set; }

Property Value¶

int

Series¶

Series for a bar chart

public ExcelChartSeries<ExcelBarChartSerie> Series { get; }

Property Value¶

ExcelChartSeries<ExcelBarChartSerie>

Shape¶

The shape of the bar/columns

public eShape Shape { get; }

Property Value¶

eShape