Class ExcelChartStandard¶

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

Base class for Chart object.

public class ExcelChartStandard : ExcelChart, IDisposable

Inheritance¶

object ← XmlHelper ← ExcelDrawing ← ExcelChart ← ExcelChartStandard

Derived¶

ExcelAreaChart
ExcelBarChart
ExcelBubbleChart
ExcelPieChart
ExcelRadarChart
ExcelScatterChart
ExcelStandardChartWithLines
ExcelSurfaceChart

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

Axis array

public ExcelChartAxisStandard[] Axis { get; }

Property Value¶

ExcelChartAxisStandard[]

Border¶

Border

public override ExcelDrawingBorder Border { get; }

Property Value¶

ExcelDrawingBorder

DisplayBlanksAs¶

Specifies the possible ways to display blanks

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

Grouping¶

Specifies the kind of grouping for a column, line, or area chart

public eGrouping Grouping { get; }

Property Value¶

eGrouping

HasLegend¶

If the chart has a legend

public override bool HasLegend { get; }

Property Value¶

bool

HasTitle¶

True if the chart has a title

public override bool HasTitle { get; }

Property Value¶

bool

Legend¶

Legend

public ExcelChartLegend Legend { get; }

Property Value¶

ExcelChartLegend

PlotArea¶

Plotarea

public override ExcelChartPlotArea PlotArea { get; }

Property Value¶

ExcelChartPlotArea

RoundedCorners¶

Border rounded corners

public override bool RoundedCorners { get; set; }

Property Value¶

bool

ShowDataLabelsOverMaximum¶

Specifies data labels over the maximum of the chart shall be shown

public override bool ShowDataLabelsOverMaximum { get; set; }

Property Value¶

bool

ShowHiddenData¶

Show data in hidden rows and columns

public override bool ShowHiddenData { get; set; }

Property Value¶

bool

Style¶

The build-in chart styles.

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¶

Title of the chart

public ExcelChartTitleStandard Title { get; }

Property Value¶

ExcelChartTitleStandard

VaryColors¶

If the chart has only one serie this varies the colors for each point.

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 ExcelChartAxisStandard XAxis { get; }

Property Value¶

ExcelChartAxisStandard

YAxis¶

The Y Axis

public ExcelChartAxisStandard YAxis { get; }

Property Value¶

ExcelChartAxisStandard

Methods¶

DeleteTitle()¶

Remove the title from the chart

public override void DeleteTitle()

GetChartNodeText()¶

Get the name of the chart node

protected string GetChartNodeText()

Returns¶

string

The name