Class ExcelChartAxis

An axis for a chart

Inheritance
System.Object
XmlHelper
ExcelChartAxis
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 sealed class ExcelChartAxis : XmlHelper, IDrawingStyle, IDrawingStyleBase, IStyleMandatoryProperties

Properties

AxisPosition

Where the axis is located

Declaration
public 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 eCrossBetween CrossBetween { get; set; }
Property Value
Type Description
eCrossBetween

Crosses

Where the axis crosses

Declaration
public eCrosses Crosses { get; set; }
Property Value
Type Description
eCrosses

CrossesAt

The value where the axis cross. Null is automatic

Declaration
public double? CrossesAt { get; set; }
Property Value
Type Description
System.Nullable<System.Double>

Deleted

If the axis is deleted

Declaration
public bool Deleted { get; set; }
Property Value
Type Description
System.Boolean

DisplayUnit

The scaling value of the display units for the value axis

Declaration
public 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 eTickLabelPosition LabelPosition { get; set; }
Property Value
Type Description
eTickLabelPosition

LogBase

The base for a logaritmic scale Null for a normal scale

Declaration
public 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 eAxisTickMark MajorTickMark { get; set; }
Property Value
Type Description
eAxisTickMark

MajorTimeUnit

Major time unit for the axis. Null is automatic

Declaration
public eTimeUnit? MajorTimeUnit { get; set; }
Property Value
Type Description
System.Nullable<eTimeUnit>

MajorUnit

Major unit for the axis. Null is automatic

Declaration
public double? MajorUnit { get; set; }
Property Value
Type Description
System.Nullable<System.Double>

MaxValue

Max value for the axis. Null is automatic

Declaration
public 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 eAxisTickMark MinorTickMark { get; set; }
Property Value
Type Description
eAxisTickMark

MinorTimeUnit

Minor time unit for the axis. Null is automatic

Declaration
public eTimeUnit? MinorTimeUnit { get; set; }
Property Value
Type Description
System.Nullable<eTimeUnit>

MinorUnit

Minor unit for the axis. Null is automatic

Declaration
public double? MinorUnit { get; set; }
Property Value
Type Description
System.Nullable<System.Double>

MinValue

Minimum value for the axis. Null is automatic

Declaration
public double? MinValue { get; set; }
Property Value
Type Description
System.Nullable<System.Double>

Orientation

Axis orientation

Declaration
public 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 eTickLabelPosition TickLabelPosition { get; set; }
Property Value
Type Description
eTickLabelPosition

Title

Chart axis title

Declaration
public ExcelChartTitle Title { get; }
Property Value
Type Description
ExcelChartTitle

Methods

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