Click or drag to resize

IChartCategoryAxis Interface

Represents category axis of the chart.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public interface IChartCategoryAxis : IChartValueAxis, 
	IChartAxis

The IChartCategoryAxis type exposes the following members.

Properties
Name Description
Public property Alignment
Represents alignment for the tick label.
(Inherited from IChartAxis .)
Public property Code example AxisBetweenCategories
If true - cuts unused plot area. Default for area, surface charts.
Examples
The following code illustrates how to set AxisBetweenCategories to "false" so that chart serie would be plotted on the tick marks:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category axis IsBetween</para><para>categoryAxis.AxisBetweenCategories = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example AxisType
Returns type of the axis. Read-only.
Examples
The following code illustrates how to access the AxisType property:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10000";
 worksheet.Range["B2"].Text = "20000";
 worksheet.Range["C2"].Text = "30000";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartAxis chartAxis = chart.PrimaryValueAxis;</para><para>//Get axis type</para><para>Console.WriteLine(chartAxis.AxisType);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example BaseUnit
Represents base unit for the specified category axis.
Examples
The following code illustrates how to set BaseUnit for IChartCategoryAxis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category type</para><para>categoryAxis.CategoryType = CategoryType.Time;</para><para>//Set base unit</para><para>categoryAxis.BaseUnit = ChartBaseUnitType.Year;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property BaseUnitIsAuto
True if use automatic base units for the specified category axis.
Public property Code example Border
Represents chart border. Read only.
Examples
The following code illustrates how to set color to IChart.PrimaryCategoryAxis's border using Border property:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set border and color</para><para>IChartBorder border = categoryAxis.Border;</para><para>border.Color = Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example CategoryLabels
Category labels for the chart.
Examples
The following code illustrates how to access the category labels range:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Get category label range . Output will be A1:C1</para><para>Console.WriteLine(categoryAxis.CategoryLabels.RangeAddressLocal);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example CategoryType
Represents axis category type.
Examples
The following code illustrates how to set CategoryType.Time to CategoryType:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category type</para><para>categoryAxis.CategoryType = CategoryType.Time;</para><para>//Set base unit</para><para>categoryAxis.BaseUnit = ChartBaseUnitType.Year;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Chart3DOptions
Gets the three_ D.
(Inherited from IChartAxis .)
Public property Code example CrossesAt
Represents the point on the axis another axis crosses it.
Examples
The following code illustrates how to set CrossesAt for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set CrossAt</para><para>valueAxis.CrossesAt = 15;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property CrossingPoint
Value axis / category crossing point (2D charts only).
Public property Code example CrossValue
Value where category axis crosses.
Examples
The following code illustrates how to set CrossValue for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set CrossValue</para><para>valueAxis.CrossValue = 15;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property EnteredDirectlyCategoryLabels
Entered directly category labels for the chart.
Public property Code example Font
Returns font used for axis text displaying. Read-only.
Examples
The following code illustrates how to set font color to the IChart.PrimaryCategoryAxis's category labels using Font property:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart axis</para><para>IChartAxis chartAxis =chart.PrimaryCategoryAxis;</para><para>//Set font color</para><para>chartAxis.Font.Color = Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example HasMajorGridLines
Gets or sets if axis has major gridlines.
Examples
The following code illustrates how to set visibility of MajorGridLines of IChart.PrimaryCategoryAxis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart axis</para><para>IChartAxis chartAxis =chart.PrimaryCategoryAxis;</para><para>//Set visibility</para><para>chartAxis.HasMajorGridLines = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example HasMinorGridLines
Gets or sets if axis has minor gridlines.
Examples
The following code illustrates how to set visibility of MinorGridLines of IChart.PrimaryCategoryAxis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart axis</para><para>IChartAxis chartAxis =chart.PrimaryCategoryAxis;</para><para>//Set visibility</para><para>chartAxis.HasMinorGridLines = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example IsAutoCross
Automatic category crossing point selected.
Examples
The following code illustrates how to access IsAutoCross:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set CrossAt</para><para>valueAxis.CrossesAt = 15;</para><para>//Check IsAutoCross</para><para>Console.WriteLine(valueAxis.IsAutoCross);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example IsAutoMajor
Automatic major selected.
Examples
The following code illustrates how to access IsAutoMajor:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Check IsAutoMajor</para><para>Console.WriteLine(valueAxis.IsAutoMajor);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example IsAutoMax
Automatic maximum selected.
Examples
The following code illustrates how to access IsAutoMax:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Check IsAutoMax</para><para>Console.WriteLine(valueAxis.IsAutoMax);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example IsAutoMin
Automatic minimum selected.
Examples
The following code illustrates how to access IsAutoMin:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Check IsAutoMin</para><para>Console.WriteLine(valueAxis.IsAutoMin);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example IsAutoMinor
Automatic minor selected.
Examples
The following code illustrates how to access IsAutoMinor:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Check IsAutoMinor</para><para>Console.WriteLine(valueAxis.IsAutoMinor);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example IsLogScale
Logarithmic scale.
Examples
The following code illustrates how to set IsLogScale for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set IsLogScale</para><para>valueAxis.IsLogScale = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example IsMaxCross
Category axis to cross at maximum value.
Examples
The following code illustrates how to access IsMaxCross:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Get IsMaxCross</para><para>Console.WriteLine(valueAxis.IsMaxCross);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example IsReverseOrder
Values in reverse order.
Examples
The following code illustrates how to set IsReverseOrder for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set IsReverseOrder</para><para>valueAxis.IsReverseOrder = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property IsSourceLinked
Gets or sets a value indicating whether the source is linked.
(Inherited from IChartAxis .)
Public property LabelFrequency
Frequency of labels.
Public property Code example MajorGridLines
Represents major gridLines. Read-only.
Examples
The following code illustrates how to access MajorGridLines of IChart.PrimaryCategoryAxis and set colors to it:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart axis</para><para>IChartAxis chartAxis =chart.PrimaryCategoryAxis;</para><para>//Set visibility</para><para>chartAxis.HasMajorGridLines = true;</para><para>//Set grid lines</para><para>IChartGridLine gridLine = chartAxis.MajorGridLines;</para><para>gridLine.LineProperties.Color = Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example MajorTickMark
Represents major tick marks.
Examples
The following code illustrates how to set TickMarkType.TickMarkCross to MajorTickMark:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category minor tick type</para><para>categoryAxis.MajorTickMark = TickMarkType.TickMarkCross;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example MajorUnit
Value of major increment.
Examples
The following code illustrates how to set major axis increment unit for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set major unit</para><para>valueAxis.MajorUnit = 20;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property MajorUnitScale
Represens the major unit scale value for the category axis when the CategoryType property is set to TimeScale.
Public property Code example MaxValue
Maximum value on axis.
Examples
The following code illustrates how to set MinValue and MaxValue for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set min and max value</para><para>valueAxis.MinValue = -20;</para><para>valueAxis.MaxValue = 60;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example MinorGridLines
Represents minor gridLines. Read-only.
Examples
The following code illustrates how to access MinorGridLines of IChart.PrimaryCategoryAxis and set colors to it:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart axis</para><para>IChartAxis chartAxis =chart.PrimaryCategoryAxis;</para><para>//Set visibility</para><para>chartAxis.HasMinorGridLines = true;</para><para>//Set grid lines</para><para>IChartGridLine gridLine = chartAxis.MinorGridLines;</para><para>gridLine.LineProperties.Color = Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example MinorTickMark
Represents minor tick marks.
Examples
The following code illustrates how to set TickMarkType.TickMarkCross to MinorTickMark:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category minor tick type</para><para>categoryAxis.MinorTickMark = TickMarkType.TickMarkCross;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example MinorUnit
Value of minor increment.
Examples
The following code illustrates how to set minor axis increment unit for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set major unit</para><para>valueAxis.MinorUnit = 8;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property MinorUnitScale
Represens the minor unit scale value for the category axis when the CategoryType property is set to TimeScale.
Public property Code example MinValue
Maximum value on axis.
Examples
The following code illustrates how to set MinValue and MaxValue for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartValueAxis valueAxis = chart.PrimaryValueAxis;</para><para>//Set min and max value</para><para>valueAxis.MinValue = -20;</para><para>valueAxis.MaxValue = 60;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartValueAxis .)
Public property Code example NumberFormat
Gets or sets number format string.
Examples
The following code illustrates how to set currency format "$#,##0_);($#,##0)" to NumberFormat to display value in the PrimaryValueAxis as currency:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10000";
 worksheet.Range["B2"].Text = "20000";
 worksheet.Range["C2"].Text = "30000";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartAxis chartAxis = chart.PrimaryValueAxis;</para><para>//Set number format</para><para>chartAxis.NumberFormat = @"$#,##0_);($#,##0)";</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Offset
Represents distance between the labels and axis line. The value can be from 0 through 1000.
Public property Shadow
Returns the Shadow properties.Read-only.
(Inherited from IChartAxis .)
Public property TextDirection
axis's text direction
(Inherited from IChartAxis .)
Public property Code example TextRotationAngle
Text rotation angle. Should be integer value between -90 and 90.
Examples
The following code illustrates how to set TextRotationAngle for IChart.PrimaryCategoryAxis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartAxis chartAxis =chart.PrimaryCategoryAxis;</para><para>//Set text rotation angle</para><para>chartAxis.TextRotationAngle = 90;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example TickLabelPosition
Represents tick label position.
Examples
The following code illustrates how to set TickLabelPositionType.TickLabelPositionHigh to TickLabelPosition property:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category tick labels position</para><para>categoryAxis.TickLabelPosition = TickLabelPositionType.TickLabelPositionHigh;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example TickLabelSpacing
Represents the number of categories or series between tick-mark labels.
Examples
The following code illustrates how to set TickLabelSpacing for chart axis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart category axis</para><para>IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set tick label spacing</para><para>categoryAxis.TickLabelSpacing = 2;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property TickMarksFrequency
Frequency of tick marks.
Public property Code example TickMarkSpacing
Represents the number of categories or series between tick marks.
Examples
The following code illustrates how to set TickMarkSpacing for chart axis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart category axis</para><para>IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set tick mark spacing</para><para>categoryAxis.TickMarkSpacing = 2;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example Title
Axis title.
Examples
The following code illustrates how to set Title for the IChart.PrimaryCategoryAxis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category title</para><para>categoryAxis.Title = "Categories";</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example TitleArea
Returns text area for the axis title. Read-only.
Examples
The following code illustrates how to set foreground color to IChart.PrimaryCategoryAxis's title area using TitleArea property:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart category axis</para><para>IChartAxis categoryAxis = chart.PrimaryCategoryAxis;</para><para>//Set category title</para><para>categoryAxis.Title = "Categories";</para><para>//Set title area</para><para>IChartTextArea titleArea = categoryAxis.TitleArea;</para><para>//Set color</para><para>titleArea.FrameFormat.Fill.ForeKnownColor = ExcelColors.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Public property Code example Visible
Indicates is axis is visible.
Examples
The following code illustrates how to set visibility of IChart.PrimaryCategoryAxis:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart axis</para><para>IChartAxis chartAxis =chart.PrimaryCategoryAxis;</para><para>//Set visibility</para><para>chartAxis.Visible = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from IChartAxis .)
Top
See Also