Syncfusion.XlsIO.Base
Example 


LayoutTarget Property (IChartLayout)

Gets or sets the layout target for the plot area. The LayoutTarget property values are from LayoutTargets.
Syntax
'Declaration
 
Property LayoutTarget As LayoutTargets
'Usage
 
Dim instance As IChartLayout
Dim value As LayoutTargets
 
instance.LayoutTarget = value
 
value = instance.LayoutTarget
LayoutTargets LayoutTarget {get; set;}
Remarks
The layout option LayoutTarget is supported only for plot area. To know more about charts refer this link.
Example
The following code illustrates the use of LayoutTarget 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"];  
        
        //Manually positioning plot area
        chart.PlotArea.Layout.Height = 300;
        chart.PlotArea.Layout.Width = 430;
        chart.PlotArea.Layout.Top = 40;
        chart.PlotArea.Layout.Left = 10;
        
        //sets the layout target for the plot area
        chart.PlotArea.Layout.LayoutTarget = LayoutTargets.inner; 
        
        workbook.SaveAs("Charts.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also