Class ExcelChartAxis

An axis for a chart

Inheritance

System.Object

XmlHelper

ExcelChartAxis

ExcelChartExAxis

ExcelChartAxisStandard

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Drawing.Chart

Assembly: EPPlus.dll

Syntax

public abstract class ExcelChartAxis : XmlHelper, IDrawingStyle, IDrawingStyleBase, IStyleMandatoryProperties

Fields

_chart

Type of axis

Declaration

protected ExcelChart _chart

Field Value

Type	Description
ExcelChart

_nsPrefix

Declaration

protected string _nsPrefix

Field Value

Type	Description
System.String

_title

Chart axis title

Declaration

protected ExcelChartTitle _title

Field Value

Type	Description
ExcelChartTitle

Properties

AxisPosition

Where the axis is located

Declaration

public abstract eAxisPosition AxisPosition { get; }

Property Value

Type	Description
eAxisPosition

Border

Access to border properties

Declaration

public ExcelDrawingBorder Border { get; }

Property Value

Type	Description
ExcelDrawingBorder

CrossBetween

How the axis are crossed

Declaration

public abstract eCrossBetween CrossBetween { get; set; }

Property Value

Type	Description
eCrossBetween

Crosses

Where the axis crosses

Declaration

public abstract eCrosses Crosses { get; set; }

Property Value

Type	Description
eCrosses

CrossesAt

The value where the axis cross. Null is automatic

Declaration

public abstract double? CrossesAt { get; set; }

Property Value

Type	Description
System.Nullable<System.Double>

Deleted

If the axis is deleted

Declaration

public abstract bool Deleted { get; set; }

Property Value

Type	Description
System.Boolean

DisplayUnit

The scaling value of the display units for the value axis

Declaration

public abstract double DisplayUnit { get; set; }

Property Value

Type	Description
System.Double

Effect

Effects

Declaration

public ExcelDrawingEffectStyle Effect { get; }

Property Value

Type	Description
ExcelDrawingEffectStyle

Fill

Access to fill properties

Declaration

public ExcelDrawingFill Fill { get; }

Property Value

Type	Description
ExcelDrawingFill

Font

Access to font properties

Declaration

public ExcelTextFont Font { get; }

Property Value

Type	Description
ExcelTextFont

Format

The Numberformat used

Declaration

public string Format { get; set; }

Property Value

Type	Description
System.String

HasMajorGridlines

True if the axis has major Gridlines

Declaration

public bool HasMajorGridlines { get; }

Property Value

Type	Description
System.Boolean

HasMinorGridlines

True if the axis has minor Gridlines

Declaration

public bool HasMinorGridlines { get; }

Property Value

Type	Description
System.Boolean

LabelPosition

The Position of the labels

Declaration

public abstract eTickLabelPosition LabelPosition { get; set; }

Property Value

Type	Description
eTickLabelPosition

LogBase

The base for a logaritmic scale Null for a normal scale

Declaration

public abstract double? LogBase { get; set; }

Property Value

Type	Description
System.Nullable<System.Double>

MajorGridlineEffects

Effects for major gridlines for the axis

Declaration

public ExcelDrawingEffectStyle MajorGridlineEffects { get; }

Property Value

Type	Description
ExcelDrawingEffectStyle

MajorGridlines

Major gridlines for the axis

Declaration

public ExcelDrawingBorder MajorGridlines { get; }

Property Value

Type	Description
ExcelDrawingBorder

MajorTickMark

Get or Sets the major tick marks for the axis.

Declaration

public abstract eAxisTickMark MajorTickMark { get; set; }

Property Value

Type	Description
eAxisTickMark

MajorTimeUnit

Major time unit for the axis. Null is automatic

Declaration

public abstract eTimeUnit? MajorTimeUnit { get; set; }

Property Value

Type	Description
System.Nullable<eTimeUnit>

MajorUnit

Major unit for the axis. Null is automatic

Declaration

public abstract double? MajorUnit { get; set; }

Property Value

Type	Description
System.Nullable<System.Double>

MaxValue

Max value for the axis. Null is automatic

Declaration

public abstract double? MaxValue { get; set; }

Property Value

Type	Description
System.Nullable<System.Double>

MinorGridlineEffects

Effects for minor gridlines for the axis

Declaration

public ExcelDrawingEffectStyle MinorGridlineEffects { get; }

Property Value

Type	Description
ExcelDrawingEffectStyle

MinorGridlines

Minor gridlines for the axis

Declaration

public ExcelDrawingBorder MinorGridlines { get; }

Property Value

Type	Description
ExcelDrawingBorder

MinorTickMark

Get or Sets the minor tick marks for the axis.

Declaration

public abstract eAxisTickMark MinorTickMark { get; set; }

Property Value

Type	Description
eAxisTickMark

MinorTimeUnit

Minor time unit for the axis. Null is automatic

Declaration

public abstract eTimeUnit? MinorTimeUnit { get; set; }

Property Value

Type	Description
System.Nullable<eTimeUnit>

MinorUnit

Minor unit for the axis. Null is automatic

Declaration

public abstract double? MinorUnit { get; set; }

Property Value

Type	Description
System.Nullable<System.Double>

MinValue

Minimum value for the axis. Null is automatic

Declaration

public abstract double? MinValue { get; set; }

Property Value

Type	Description
System.Nullable<System.Double>

Orientation

Axis orientation

Declaration

public abstract eAxisOrientation Orientation { get; set; }

Property Value

Type	Description
eAxisOrientation

SourceLinked

The Numberformats are linked to the source data.

Declaration

public bool SourceLinked { get; set; }

Property Value

Type	Description
System.Boolean

TextBody

Access to text body properties

Declaration

public ExcelTextBody TextBody { get; }

Property Value

Type	Description
ExcelTextBody

ThreeD

3D properties

Declaration

public ExcelDrawing3D ThreeD { get; }

Property Value

Type	Description
ExcelDrawing3D

TickLabelPosition

Position of the Lables

Declaration

public abstract eTickLabelPosition TickLabelPosition { get; set; }

Property Value

Type	Description
eTickLabelPosition

Title

Declaration

public virtual ExcelChartTitle Title { get; }

Property Value

Type	Description
ExcelChartTitle

Methods

AddGridlines(Boolean, Boolean)

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

Declaration

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

Parameters

Type	Name	Description
System.Boolean	addMajor	Indicates if the Major gridlines should be added
System.Boolean	addMinor	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

Declaration

public void AddTitle(string title)

Parameters

Type	Name	Description
System.String	title

AddTitleNode()

Declaration

protected XmlNode AddTitleNode()

Returns

Type	Description
System.Xml.XmlNode

GetTitle()

Declaration

protected abstract ExcelChartTitle GetTitle()

Returns

Type	Description
ExcelChartTitle

RemoveGridlines()

Removes Major and Minor gridlines from the Axis

Declaration

public void RemoveGridlines()

RemoveGridlines(Boolean, Boolean)

Removes gridlines from the Axis

Declaration

public void RemoveGridlines(bool removeMajor, bool removeMinor)

Parameters

Type	Name	Description
System.Boolean	removeMajor	Indicates if the Major gridlines should be removed
System.Boolean	removeMinor	Indicates if the Minor gridlines should be removed

RemoveTitle()

Removes the axis title

Declaration

public void RemoveTitle()