Table of Contents

Class XlsChartSeriesAxis

Namespace
Spire.Xls.Core.Spreadsheet.Charts
Assembly
Spire.XLS.dll
public class XlsChartSeriesAxis : XlsChartAxis, IExcelApplication, IDisposable, IChartSeriesAxis, IChartAxis
Inheritance
XlsChartSeriesAxis
Implements
Derived
Inherited Members

Fields

DefaultSeriesAxisId 

public const int DefaultSeriesAxisId = 63149376

Field Value

int

Properties

CrossesAt 

public int CrossesAt { get; set; }

Property Value

int

IsBetween 

public bool IsBetween { get; set; }

Property Value

bool

IsLogScale 

public bool IsLogScale { get; set; }

Property Value

bool

IsReverseOrder

Display categories in reverse order.

public bool IsReverseOrder { get; set; }

Property Value

bool

LabelsFrequency

Represents the number of categories or series between tick-mark labels.

public int LabelsFrequency { get; set; }

Property Value

int

LogBase 

public double LogBase { get; set; }

Property Value

double

MaxValue 

public double MaxValue { get; set; }

Property Value

double

MinValue 

public double MinValue { get; set; }

Property Value

double

TickLabelSpacing

Represents the number of categories or series between tick-mark labels.

public int TickLabelSpacing { get; set; }

Property Value

int

TickMarkSpacing

Represents the number of categories or series between tick marks.

public int TickMarkSpacing { get; set; }

Property Value

int

TickMarksFrequency

Frequency of tick marks. The following code illustrates how to set TickMarksFrequency for IChartSeriesAxis:

//Create worksheetWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");Worksheet worksheet = workbook.Worksheets[0];//Create chartIChart chart = worksheet.Charts.Add();//Set rangechart.DataRange = worksheet.Range["A1:C3"];//Set chart typechart.ChartType = ExcelChartType.Column3D;//Set tick mark frequencychart.PrimarySerieAxis.TickMarksFrequency = 2;//Save to fileworkbook.SaveToFile("Chart.xlsx");
public int TickMarksFrequency { get; set; }

Property Value

int

Methods

Clone(object, Dictionary<int, int>, Dictionary<string, string>) 

[Obsolete("the method is not implemented")]
public override XlsChartAxis Clone(object parent, Dictionary<int, int> dicFontIndexes, Dictionary<string, string> dicNewSheetNames)

Parameters

parent object
dicFontIndexes Dictionary<int, int>
dicNewSheetNames Dictionary<string, string>

Returns

XlsChartAxis