Click or drag to resize

IChartValueAxis Properties

The IChartValueAxis 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 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>
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>
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>
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>
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>
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>
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>
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>
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>
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>
Public property IsSourceLinked
Gets or sets a value indicating whether the source is linked.
(Inherited from IChartAxis .)
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>
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>
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>
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>
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 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