Click or drag to resize

IChartSeriesAxis Interface

Represents the chart series Axis.

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

The IChartSeriesAxis type exposes the following members.

Properties
Name Description
Public property Alignment
Represents alignment for the tick label.
(Inherited from IChartAxis .)
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 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 Chart3DOptions
Gets the three_ D.
(Inherited from IChartAxis .)
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 IsSourceLinked
Gets or sets a value indicating whether the source is linked.
(Inherited from IChartAxis .)
Public property Code example LabelsFrequency
Frequency of labels.
Examples
The following code illustrates how to set LabelsFrequency for IChartSeriesAxis:
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>IChart chart = worksheet.Charts.Add();</para><para>//Set range</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Column3D;</para><para>//Set LabelsFrequency</para><para>chart.PrimarySerieAxis.LabelsFrequency = 2;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
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 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 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 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 IChartSeriesAxis:
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>IChart chart = worksheet.Charts.Add();</para><para>//Set range</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Column3D;</para><para>//Set tick label spacing</para><para>chart.PrimarySerieAxis.TickLabelSpacing = 2;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example TickMarksFrequency
Represents the number of categories or series between tick marks.
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