Syncfusion.XlsIO.Base
Example 


ManualLayout Property (IChartLayout)

Gets or sets manual layout options for the chart element. The Layout and ManualLayout options both are same.
Syntax
'Declaration
 
Property ManualLayout As IChartManualLayout
'Usage
 
Dim instance As IChartLayout
Dim value As IChartManualLayout
 
instance.ManualLayout = value
 
value = instance.ManualLayout
IChartManualLayout ManualLayout {get; set;}
Remarks
To know more about charts refer this link.
Example
The following code illustrates the use of ManualLayout 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.ManualLayout.Height = 300;
        chart.PlotArea.Layout.ManualLayout.Width = 430;
        chart.PlotArea.Layout.ManualLayout.Top = 40;
        chart.PlotArea.Layout.ManualLayout.Left = 10;
        chart.PlotArea.Layout.ManualLayout.LayoutTarget = LayoutTargets.inner;
        chart.PlotArea.Layout.ManualLayout.LeftMode = LayoutModes.edge;
        chart.PlotArea.Layout.ManualLayout.TopMode = LayoutModes.factor;
            
        //Manually positioning legent area
        chart.Legend.Layout.ManualLayout.Height = 160;
        chart.Legend.Layout.ManualLayout.Width = 120;
        chart.Legend.Layout.ManualLayout.Top = 30;
        chart.Legend.Layout.ManualLayout.Left = 220;
        chart.Legend.Layout.ManualLayout.LeftMode = LayoutModes.edge;
        chart.Legend.Layout.ManualLayout.TopMode = LayoutModes.factor;
            
        //Manually positioning text Area
        chart.ChartTitleArea.Text = "Sample Chart";
        chart.ChartTitleArea.Layout.ManualLayout.Height = 20;
        chart.ChartTitleArea.Layout.ManualLayout.Width = 30;
        chart.ChartTitleArea.Layout.ManualLayout.Top = 0;
        chart.ChartTitleArea.Layout.ManualLayout.Left = 150;
        chart.ChartTitleArea.Layout.ManualLayout.LeftMode = LayoutModes.edge;
        chart.ChartTitleArea.Layout.ManualLayout.TopMode = LayoutModes.factor;
        workbook.SaveAs("Charts.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also