Interface IChartValueAxis

Namespace

Spire.Xls.Core

Assembly

Spire.XLS.dll

Represents the chart value axis.

public interface IChartValueAxis : IChartAxis

Inherited Members

IChartAxis.NumberFormat

IChartAxis.AxisType

IChartAxis.Title

IChartAxis.TextRotationAngle

IChartAxis.TitleArea

IChartAxis.Font

IChartAxis.MajorGridLines

IChartAxis.MinorGridLines

IChartAxis.HasMinorGridLines

IChartAxis.HasMajorGridLines

IChartAxis.MinorTickMark

IChartAxis.MajorTickMark

IChartAxis.Border

IChartAxis.TickLabelPosition

IChartAxis.Visible

IChartAxis.Alignment

IChartAxis.Shadow

IChartAxis.Chart3DOptions

IChartAxis.IsSourceLinked

IChartAxis.TextDirection

Properties

CrossValue

Value where category axis crosses. The following code illustrates how to set CrossValue for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set CrossValue
valueAxis.CrossValue = 15;

//Save to file
workbook.SaveToFile("Chart.xlsx");

double CrossValue { get; set; }

Property Value

double

CrossesAt

Represents the point on the axis another axis crosses it. The following code illustrates how to set CrossesAt for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set CrossAt
valueAxis.CrossesAt = 15;

//Save to file
workbook.SaveToFile("Chart.xlsx");

double CrossesAt { get; set; }

Property Value

double

IsAutoCross

Automatic category crossing point selected. The following code illustrates how to access IsAutoCross:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set CrossAt
valueAxis.CrossesAt = 15;

//Check IsAutoCross
Console.WriteLine(valueAxis.IsAutoCross);

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsAutoCross { get; }

Property Value

bool

IsAutoMajor

Automatic major selected. The following code illustrates how to access IsAutoMajor:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Check IsAutoMajor
Console.WriteLine(valueAxis.IsAutoMajor);

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsAutoMajor { get; set; }

Property Value

bool

IsAutoMax

Automatic maximum selected. The following code illustrates how to access IsAutoMax:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Check IsAutoMax
Console.WriteLine(valueAxis.IsAutoMax);

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsAutoMax { get; set; }

Property Value

bool

IsAutoMin

Automatic minimum selected. The following code illustrates how to access IsAutoMin:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Check IsAutoMin
Console.WriteLine(valueAxis.IsAutoMin);

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsAutoMin { get; set; }

Property Value

bool

IsAutoMinor

Automatic minor selected. The following code illustrates how to access IsAutoMinor:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Check IsAutoMinor
Console.WriteLine(valueAxis.IsAutoMinor);

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsAutoMinor { get; set; }

Property Value

bool

IsLogScale

Logarithmic scale. The following code illustrates how to set IsLogScale for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set IsLogScale
valueAxis.IsLogScale = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsLogScale { get; set; }

Property Value

bool

IsMaxCross

Category axis to cross at maximum value. The following code illustrates how to access IsMaxCross:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Get IsMaxCross
Console.WriteLine(valueAxis.IsMaxCross);

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsMaxCross { get; }

Property Value

bool

IsReverseOrder

Values in reverse order. The following code illustrates how to set IsReverseOrder for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set IsReverseOrder
valueAxis.IsReverseOrder = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");

bool IsReverseOrder { get; set; }

Property Value

bool

MajorUnit

Value of major increment. The following code illustrates how to set major axis increment unit for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set major unit
valueAxis.MajorUnit = 20;

//Save to file
workbook.SaveToFile("Chart.xlsx");

double MajorUnit { get; set; }

Property Value

double

MaxValue

Maximum value on axis. The following code illustrates how to set MinValue and MaxValue for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set min and max value
valueAxis.MinValue = -20;
valueAxis.MaxValue = 60;

//Save to file
workbook.SaveToFile("Chart.xlsx");

double MaxValue { get; set; }

Property Value

double

MinValue

Maximum value on axis. The following code illustrates how to set MinValue and MaxValue for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set min and max value
valueAxis.MinValue = -20;
valueAxis.MaxValue = 60;

//Save to file
workbook.SaveToFile("Chart.xlsx");

double MinValue { get; set; }

Property Value

double

MinorUnit

Value of minor increment. The following code illustrates how to set minor axis increment unit for charts:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;

//Set major unit
valueAxis.MinorUnit = 8;

//Save to file
workbook.SaveToFile("Chart.xlsx");

double MinorUnit { get; set; }

Property Value

double