Class ExcelChartAxis

Namespace

OfficeOpenXml.Drawing.Chart

Assembly

EPPlus.dll

An axis for a chart

public abstract class ExcelChartAxis : XmlHelper

Inheritance

object

XmlHelper

ExcelChartAxis

Derived

ExcelChartExAxis

ExcelChartAxisStandard

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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