Syncfusion.XlsIO.Base
Example 


AutoScaling Property (IChart)

True to automatically scale the chart. otherwise False. The RightAngleAxes property must be True.
Syntax
'Declaration
 
Property AutoScaling As Boolean
'Usage
 
Dim instance As IChart
Dim value As Boolean
 
instance.AutoScaling = value
 
value = instance.AutoScaling
bool AutoScaling {get; set;}
Remarks
Excel scales a 3-D chart so that it is closer in size to the equivalent 2-D chart when this property is enabled.
Example
The following code illustrates how to set auto scaling 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 height percentage
            chart.HeightPercent = 300;
            
            //Set auto scaling
            chart.AutoScaling = true;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also