Interface IChartLayout
Provides layout options for plot area, legend and text area elements of the chart.
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public interface IChartLayout : IParentApplicationProperties
Height
Gets or sets the height/bottom of the chart element as a fraction of height of the chart, based on HeightMode.
Declaration
double Height { get; set; }Property Value
| Type |
|---|
| System.Double |
Remarks
To know more about charts refer this link.
Examples
The following code illustrates the use of Height property.
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; //sets a value of Height for plot area
chart.PlotArea.Layout.Width = 430;
chart.PlotArea.Layout.Top = 40;
chart.PlotArea.Layout.Left = 10;
//Manually positioning legent area
chart.Legend.Layout.Height = 160; //sets a value of Height for legent area
chart.Legend.Layout.Width = 120;
chart.Legend.Layout.Top = 30;
chart.Legend.Layout.Left = 220;
//Manually positioning text Area
chart.ChartTitleArea.Layout.Height = 20; //sets a value of Height for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Width = 30;
chart.ChartTitleArea.Layout.Top = 0;
chart.ChartTitleArea.Layout.Left = 150;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}HeightMode
Gets or sets a value indicating how to interpret the Height of this manual layout. The HeightMode property values are from LayoutModes.
Declaration
LayoutModes HeightMode { get; set; }Property Value
| Type |
|---|
| LayoutModes |
Remarks
To know more about charts refer this link.
Examples
The following code illustrates the use of HeightMode property.
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.HeightMode = LayoutModes.edge; //sets a value of Height mode for plot area
chart.PlotArea.Layout.Height = 300;
chart.PlotArea.Layout.Width = 430;
chart.PlotArea.Layout.Top = 40;
chart.PlotArea.Layout.Left = 10;
//Manually positioning legent area
chart.Legend.Layout.HeightMode = LayoutModes.edge; //sets a value of Height mode for legent area
chart.Legend.Layout.Height = 160;
chart.Legend.Layout.Width = 120;
chart.Legend.Layout.Top = 30;
chart.Legend.Layout.Left = 220;
//Manually positioning text Area
chart.ChartTitleArea.Layout.HeightMode = LayoutModes.edge; //sets a value of Height mode for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Height = 20;
chart.ChartTitleArea.Layout.Width = 30;
chart.ChartTitleArea.Layout.Top = 0;
chart.ChartTitleArea.Layout.Left = 150;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}LayoutTarget
Gets or sets the layout target for the plot area. The LayoutTarget property values are from LayoutTargets.
Declaration
LayoutTargets LayoutTarget { get; set; }Property Value
| Type |
|---|
| LayoutTargets |
Remarks
The layout option LayoutTarget is supported only for plot area. To know more about charts refer this link.
Examples
The following code illustrates the use of LayoutTarget property.
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();
}Left
Gets or sets the left (x location) of the chart element as a fraction of width of the chart.
Declaration
double Left { get; set; }Property Value
| Type |
|---|
| System.Double |
Remarks
If LeftMode is factor, then the position is relative to the default position for the chart element. To know more about charts refer this link.
Examples
The following code illustrates the use of Left property.
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.Left = 10; //sets a value of left position for plot area
chart.PlotArea.Layout.Height = 300;
chart.PlotArea.Layout.Width = 430;
chart.PlotArea.Layout.Top = 40;
//Manually positioning legent area
chart.Legend.Layout.Left = 220; //sets a value of left position for legent area
chart.Legend.Layout.Height = 160;
chart.Legend.Layout.Width = 120;
chart.Legend.Layout.Top = 30;
//Manually positioning text Area
chart.ChartTitleArea.Layout.Left = 150; //sets a value of left position for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Height = 20;
chart.ChartTitleArea.Layout.Width = 30;
chart.ChartTitleArea.Layout.Top = 0;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}LeftMode
Gets or sets a value indicating how to interpret the Left of this manual layout. The LeftMode property values are from LayoutModes.
Declaration
LayoutModes LeftMode { get; set; }Property Value
| Type |
|---|
| LayoutModes |
Remarks
To know more about charts refer this link.
Examples
The following code illustrates the use of LeftMode property.
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.LeftMode = LayoutModes.edge; //sets a value of Leftmode for plot area
chart.PlotArea.Layout.Height = 300;
chart.PlotArea.Layout.Width = 430;
chart.PlotArea.Layout.Top = 40;
chart.PlotArea.Layout.Left = 10;
//Manually positioning legent area
chart.Legend.Layout.LeftMode = LayoutModes.edge; //sets a value of Leftmode for legent area
chart.Legend.Layout.Height = 160;
chart.Legend.Layout.Width = 120;
chart.Legend.Layout.Top = 30;
chart.Legend.Layout.Left = 220;
//Manually positioning text Area
chart.ChartTitleArea.Layout.LeftMode = LayoutModes.edge; //sets a value of Leftmode for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Height = 20;
chart.ChartTitleArea.Layout.Width = 30;
chart.ChartTitleArea.Layout.Top = 0;
chart.ChartTitleArea.Layout.Left = 150;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}ManualLayout
Gets or sets manual layout options for the chart element. The Layout and ManualLayout options both are same.
Declaration
IChartManualLayout ManualLayout { get; set; }Property Value
| Type |
|---|
| IChartManualLayout |
Remarks
To know more about charts refer this link.
Examples
The following code illustrates the use of ManualLayout property.
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();
}Top
Gets or sets the top of the chart element as a fraction of height of the chart.
Declaration
double Top { get; set; }Property Value
| Type |
|---|
| System.Double |
Remarks
If TopMode is factor, then the position is relative to the default position for the chart element. To know more about charts refer this link.
Examples
The following code illustrates the use of Top property.
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.Top = 40; //sets a value of Top position for plot area
chart.PlotArea.Layout.Height = 300;
chart.PlotArea.Layout.Width = 430;
chart.PlotArea.Layout.Left = 10;
//Manually positioning legent area
chart.Legend.Layout.Top = 30; //sets a value of Top position for legent area
chart.Legend.Layout.Height = 160;
chart.Legend.Layout.Width = 120;
chart.Legend.Layout.Left = 220;
//Manually positioning text Area
chart.ChartTitleArea.Layout.Top = 0; //sets a value of Top position for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Height = 20;
chart.ChartTitleArea.Layout.Width = 30;
chart.ChartTitleArea.Layout.Left = 150;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}TopMode
Gets or sets a value indicating how to interpret the Top of this manual layout. The TopMode property values are from LayoutModes.
Declaration
LayoutModes TopMode { get; set; }Property Value
| Type |
|---|
| LayoutModes |
Remarks
To know more about charts refer this link.
Examples
The following code illustrates the use of TopMode property.
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.TopMode = LayoutModes.factor; //sets a value of topmode for plot area
chart.PlotArea.Layout.Height = 300;
chart.PlotArea.Layout.Width = 430;
chart.PlotArea.Layout.Top = 40;
chart.PlotArea.Layout.Left = 10;
//Manually positioning legent area
chart.Legend.Layout.TopMode = LayoutModes.factor; //sets a value of topmode for legent area
chart.Legend.Layout.Height = 160;
chart.Legend.Layout.Width = 120;
chart.Legend.Layout.Top = 30;
chart.Legend.Layout.Left = 220;
//Manually positioning text Area
chart.ChartTitleArea.Layout.TopMode = LayoutModes.factor; //sets a value of topmode for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Height = 20;
chart.ChartTitleArea.Layout.Width = 30;
chart.ChartTitleArea.Layout.Top = 0;
chart.ChartTitleArea.Layout.Left = 150;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}Width
Gets or sets the width/right of the chart element as a fraction of width of the chart, based on WidthMode.
Declaration
double Width { get; set; }Property Value
| Type |
|---|
| System.Double |
Remarks
To know more about charts refer this link.
Examples
The following code illustrates the use of Width property.
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.Width = 430; //sets a value of Width for plot area
chart.PlotArea.Layout.Height = 300;
chart.PlotArea.Layout.Top = 40;
chart.PlotArea.Layout.Left = 10;
//Manually positioning legent area
chart.Legend.Layout.Width = 120; //sets a value of width for legent area
chart.Legend.Layout.Height = 160;
chart.Legend.Layout.Top = 30;
chart.Legend.Layout.Left = 220;
//Manually positioning text Area
chart.ChartTitleArea.Layout.Width = 30; //sets a value of Width mode for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Height = 20;
chart.ChartTitleArea.Layout.Top = 0;
chart.ChartTitleArea.Layout.Left = 150;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}WidthMode
Gets or sets a value indicating how to interpret the Width of this manual layout. The WidthMode property values are from LayoutModes.
Declaration
LayoutModes WidthMode { get; set; }Property Value
| Type |
|---|
| LayoutModes |
Remarks
To know more about charts refer this link.
Examples
The following code illustrates the use of WidthMode property.
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.WidthMode = LayoutModes.factor; //sets a value of Width mode for plot area
chart.PlotArea.Layout.Height = 300;
chart.PlotArea.Layout.Width = 430;
chart.PlotArea.Layout.Top = 40;
chart.PlotArea.Layout.Left = 10;
//Manually positioning legent area
chart.Legend.Layout.WidthMode = LayoutModes.factor; //sets a value of Width mode for legent area
chart.Legend.Layout.Height = 160;
chart.Legend.Layout.Width = 120;
chart.Legend.Layout.Top = 30;
chart.Legend.Layout.Left = 220;
//Manually positioning text Area
chart.ChartTitleArea.Layout.WidthMode = LayoutModes.factor; //sets a value of Width mode for text area
chart.ChartTitleArea.Text = "Sample Chart";
chart.ChartTitleArea.Layout.Height = 20;
chart.ChartTitleArea.Layout.Width = 30;
chart.ChartTitleArea.Layout.Top = 0;
chart.ChartTitleArea.Layout.Left = 150;
workbook.SaveAs("Charts.xlsx");
workbook.Close();
}