Class ExcelChartAxis¶

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

An axis for a chart

public abstract class ExcelChartAxis : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelChartAxis

Derived¶

ExcelChartAxisStandard
ExcelChartExAxis

Inherited Members¶

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

Fields¶

_title¶

Chart axis title

protected ExcelChartTitle _title

Field Value¶

ExcelChartTitle

Properties¶

AxisPosition¶

Where the axis is located

public abstract eAxisPosition AxisPosition { get; }

Property Value¶

eAxisPosition

Border¶

Access to border properties

public ExcelDrawingBorder Border { get; }

Property Value¶

ExcelDrawingBorder

CrossBetween¶

How the axis are crossed

public abstract eCrossBetween CrossBetween { get; set; }

Property Value¶

eCrossBetween

Crosses¶

Where the axis crosses

public abstract eCrosses Crosses { get; set; }

Property Value¶

eCrosses

CrossesAt¶

The value where the axis cross. Null is automatic

public abstract double? CrossesAt { get; set; }

Property Value¶

double?

Deleted¶

If the axis is deleted

public abstract bool Deleted { get; set; }

Property Value¶

bool

DisplayUnit¶

The scaling value of the display units for the value axis

public abstract double DisplayUnit { get; set; }

Property Value¶

double

Effect¶

Effects

public ExcelDrawingEffectStyle Effect { get; }

Property Value¶

ExcelDrawingEffectStyle

Fill¶

Access to fill properties

public ExcelDrawingFill Fill { get; }

Property Value¶

ExcelDrawingFill

Font¶

Access to font properties

public ExcelTextFont Font { get; }

Property Value¶

ExcelTextFont

Format¶

The Numberformat used

public string Format { get; set; }

Property Value¶

string

HasMajorGridlines¶

True if the axis has major Gridlines

public bool HasMajorGridlines { get; }

Property Value¶

bool

HasMinorGridlines¶

True if the axis has minor Gridlines

public bool HasMinorGridlines { get; }

Property Value¶

bool

LabelPosition¶

The Position of the labels

public abstract eTickLabelPosition LabelPosition { get; set; }

Property Value¶

eTickLabelPosition

LogBase¶

The base for a logaritmic scale Null for a normal scale

public abstract double? LogBase { get; set; }

Property Value¶

double?

MajorGridlineEffects¶

Effects for major gridlines for the axis

public ExcelDrawingEffectStyle MajorGridlineEffects { get; }

Property Value¶

ExcelDrawingEffectStyle

MajorGridlines¶

Major gridlines for the axis

public ExcelDrawingBorder MajorGridlines { get; }

Property Value¶

ExcelDrawingBorder

MajorTickMark¶

Get or Sets the major tick marks for the axis.

public abstract eAxisTickMark MajorTickMark { get; set; }

Property Value¶

eAxisTickMark

MajorTimeUnit¶

Major time unit for the axis. Null is automatic

public abstract eTimeUnit? MajorTimeUnit { get; set; }

Property Value¶

eTimeUnit?

MajorUnit¶

Major unit for the axis. Null is automatic

public abstract double? MajorUnit { get; set; }

Property Value¶

double?

MaxValue¶

Max value for the axis. Null is automatic

public abstract double? MaxValue { get; set; }

Property Value¶

double?

MinValue¶

Minimum value for the axis. Null is automatic

public abstract double? MinValue { get; set; }

Property Value¶

double?

MinorGridlineEffects¶

Effects for minor gridlines for the axis

public ExcelDrawingEffectStyle MinorGridlineEffects { get; }

Property Value¶

ExcelDrawingEffectStyle

MinorGridlines¶

Minor gridlines for the axis

public ExcelDrawingBorder MinorGridlines { get; }

Property Value¶

ExcelDrawingBorder

MinorTickMark¶

Get or Sets the minor tick marks for the axis.

public abstract eAxisTickMark MinorTickMark { get; set; }

Property Value¶

eAxisTickMark

MinorTimeUnit¶

Minor time unit for the axis. Null is automatic

public abstract eTimeUnit? MinorTimeUnit { get; set; }

Property Value¶

eTimeUnit?

MinorUnit¶

Minor unit for the axis. Null is automatic

public abstract double? MinorUnit { get; set; }

Property Value¶

double?

Orientation¶

Axis orientation

public abstract eAxisOrientation Orientation { get; set; }

Property Value¶

eAxisOrientation

SourceLinked¶

The Numberformats are linked to the source data.

public bool SourceLinked { get; set; }

Property Value¶

bool

TextBody¶

Access to text body properties

public ExcelTextBody TextBody { get; }

Property Value¶

ExcelTextBody

TextSettings¶

String settings like fills, text outlines and effects

public ExcelDrawingTextSettings TextSettings { get; }

Property Value¶

ExcelDrawingTextSettings

ThreeD¶

3D properties

public ExcelDrawing3D ThreeD { get; }

Property Value¶

ExcelDrawing3D

TickLabelPosition¶

Position of the Lables

public abstract eTickLabelPosition TickLabelPosition { get; set; }

Property Value¶

eTickLabelPosition

Title¶

Gives access to the charts title properties.

public virtual ExcelChartTitle Title { get; }

Property Value¶

ExcelChartTitle

Methods¶

AddGridlines(bool, bool)¶

Adds gridlines and styles them according to the style selected in the StyleManager

public void AddGridlines(bool addMajor = true, bool addMinor = false)

Parameters¶

addMajor bool

Indicates if the Major gridlines should be added

addMinor bool

Indicates if the Minor gridlines should be added

AddTitle(string)¶

Adds the axis title and styles it according to the style selected in the StyleManager

public void AddTitle(string title)

Parameters¶

title string

RemoveGridlines()¶

Removes Major and Minor gridlines from the Axis

public void RemoveGridlines()

RemoveGridlines(bool, bool)¶

Removes gridlines from the Axis

public void RemoveGridlines(bool removeMajor, bool removeMinor)

Parameters¶

removeMajor bool

Indicates if the Major gridlines should be removed

removeMinor bool

Indicates if the Minor gridlines should be removed

RemoveTitle()¶

Removes the axis title

public void RemoveTitle()