Syncfusion.XlsIO.Base
Example 


CrossesAt Property (IChartValueAxis)

Represents the point on the axis another axis crosses it.
Syntax
'Declaration
 
Property CrossesAt As Double
'Usage
 
Dim instance As IChartValueAxis
Dim value As Double
 
instance.CrossesAt = value
 
value = instance.CrossesAt
double CrossesAt {get; set;}
Example
The following code illustrates how to set CrossesAt for charts.
using Syncfusion.XlsIO;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            
            //Set chart value axis
            IChartValueAxis valueAxis = chart.PrimaryValueAxis;
            
            //Set cross at
            valueAxis.CrossesAt = 15;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also