Syncfusion.XlsIO.Base
Example 


Layout Property (IChartFrameFormat)

Gets or sets the layout settings of chart text area.
Syntax
'Declaration
 
Property Layout As IChartLayout
'Usage
 
Dim instance As IChartFrameFormat
Dim value As IChartLayout
 
instance.Layout = value
 
value = instance.Layout
IChartLayout Layout {get; set;}
Remarks
To know more about charts refer this link.
Example
The following code illustrates use of Layout property.
using Syncfusion.XlsIO;
            
class Example
{
   static void Main()
   {
      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1"].Text = "Student ID";
        sheet.Range["B1"].Text = "Student Name";
        sheet.Range["C1"].Text = "Mark(Out of 100)";
        sheet.Range["A1:C1"].AutofitColumns();
        sheet.Range["A2"].Number = 1;
        sheet.Range["A3"].Number = 2;
        sheet.Range["A4"].Number = 3;
        sheet.Range["A5"].Number = 4;
        sheet.Range["A6"].Number = 5;
        sheet.Range["B2"].Text = "Andrew";
        sheet.Range["B3"].Text = "Marson";
        sheet.Range["B4"].Text = "Jack";
        sheet.Range["B5"].Text = "Sam";
        sheet.Range["B6"].Text = "Breto";
        sheet.Range["C2"].Number = 77;
        sheet.Range["C3"].Number = 45;
        sheet.Range["C4"].Number = 92;
        sheet.Range["C5"].Number = 39;
        sheet.Range["C6"].Number = 55;
        
        //Create a Chart
        IChartShape chart = sheet.Charts.Add();
        chart.LeftColumn = 5;
        chart.RightColumn = 11;
        chart.Name = "Student Sample Chart";
        chart.ChartType = ExcelChartType.Cone_Clustered_3D;
        chart.DataRange = sheet.Range["B2:C6"];
        
        //sets the layout settings of plot area
        chart.PlotArea.Layout.Height = 300;
        chart.PlotArea.Layout.Width = 430;
        chart.PlotArea.Layout.Top = 40;
        chart.PlotArea.Layout.Left = 10;
        chart.PlotArea.Layout.LayoutTarget = LayoutTargets.inner;
        chart.PlotArea.Layout.LeftMode = LayoutModes.edge;
        chart.PlotArea.Layout.TopMode = LayoutModes.factor;
        
        workbook.SaveAs("Charts.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also