Syncfusion.XlsIO.Base
Example 


UsePrimaryAxis Property (IChartSerie)

Gets or sets a boolean value indicating whether to use primary axis for series drawing. False to use secondary axis.
Syntax
'Declaration
 
Property UsePrimaryAxis As Boolean
'Usage
 
Dim instance As IChartSerie
Dim value As Boolean
 
instance.UsePrimaryAxis = value
 
value = instance.UsePrimaryAxis
bool UsePrimaryAxis {get; set;}
Example
The following code illustrates how the secondary axis can be used by disabling primary axis.
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";
            sheet.Range["A3"].Value = "100";
            sheet.Range["B3"].Value = "200";
            sheet.Range["C3"].Value = "300";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C3"];
            
            //Set secondary axis
            IChartSerie serie = chart.Series[1];
            serie.UsePrimaryAxis = false;
            chart.SecondaryCategoryAxis.Visible = true;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also