Which of the following statements for sizing and positioning a chart object is not true?

Working with charts using various operations

28 Jul 202224 minutes to read

Essential XlsIO has support for creating and modifying Excel charts inside a workbook or as a chart worksheet.

Creating a Chart 

The IChartShape interface represents the chart in a worksheet. A chart can be created either through the existing data in the worksheet, directly entering series or by adding series one by one.

The following code example illustrates how to create a chart through the existing data in the worksheet.

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Create a Chart IChartShape chart = sheet.Charts.Add(); //Set Chart Type chart.ChartType = ExcelChartType.Column_Clustered; //Set data range in the worksheet chart.DataRange = sheet.Range["A1:E5"]; workbook.SaveAs("Chart.xlsx"); }

Using excelEngine As ExcelEngine = New ExcelEngine() Dim application As IApplication = excelEngine.Excel application.DefaultVersion = ExcelVersion.Excel2013 Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic) Dim sheet As IWorksheet = workbook.Worksheets(0) 'Create a Chart Dim chart As IChartShape = sheet.Charts.Add() 'Set Chart Type chart.ChartType = ExcelChartType.Column_Clustered 'Set data range in the worksheet chart.DataRange = sheet.Range("A1:E5") workbook.SaveAs("Chart.xlsx") End Using

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; //Instantiates the File Picker FileOpenPicker openPicker = new FileOpenPicker(); openPicker.SuggestedStartLocation = PickerLocationId.Desktop; openPicker.FileTypeFilter.Add(".xlsx"); openPicker.FileTypeFilter.Add(".xls"); StorageFile file = await openPicker.PickSingleFileAsync(); //Opens the workbook IWorkbook workbook = await application.Workbooks.OpenAsync(file, ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Create a Chart IChartShape chart = sheet.Charts.Add(); //Set Chart Type chart.ChartType = ExcelChartType.Column_Clustered; //Set data range in the worksheet chart.DataRange = sheet.Range["A1:E5"]; //Initializes FileSavePicker FileSavePicker savePicker = new FileSavePicker(); savePicker.SuggestedStartLocation = PickerLocationId.Desktop; savePicker.SuggestedFileName = "Chart"; savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlsx" }); //Creates a storage file from FileSavePicker StorageFile storageFile = await savePicker.PickSaveFileAsync(); //Saves changes to the specified storage file await workbook.SaveAsAsync(storageFile); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; FileStream inputStream = new FileStream("Sample.xlsx", FileMode.Open, FileAccess.Read); IWorkbook workbook = application.Workbooks.Open(inputStream, ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Create a Chart IChartShape chart = sheet.Charts.Add(); //Set Chart Type chart.ChartType = ExcelChartType.Column_Clustered; //Set data range in the worksheet chart.DataRange = sheet.Range["A1:E5"]; //Saving the workbook as stream FileStream stream = new FileStream("Chart.xlsx", FileMode.Create, FileAccess.ReadWrite); workbook.SaveAs(stream); stream.Dispose(); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; //"App" is the class of Portable project Assembly assembly = typeof(App).GetTypeInfo().Assembly; Stream inputStream = assembly.GetManifestResourceStream("SampleBrowser.XlsIO.Samples.Template.Sample.xlsx"); IWorkbook workbook = application.Workbooks.Open(inputStream, ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Create a Chart IChartShape chart = sheet.Charts.Add(); //Set Chart Type chart.ChartType = ExcelChartType.Column_Clustered; //Set data range in the worksheet chart.DataRange = sheet.Range["A1:E5"]; //Saving the workbook as stream MemoryStream stream = new MemoryStream(); workbook.SaveAs(stream); stream.Position = 0; //Save the document as file and view the saved document //The operation in SaveAndView under Xamarin varies between Windows Phone, Android and iOS platforms. Please refer xlsio/xamarin section for respective code samples. if (Device.OS == TargetPlatform.WinPhone || Device.OS == TargetPlatform.Windows) { Xamarin.Forms.DependencyService.Get<ISaveWindowsPhone>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } else { Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } }

A complete working example to create a chart in C# is present on this GitHub page.

Creating a Chart from directly entered Values

A chart in XlsIO can also be created from directly entered values. The Following code snippets illustrate how to create a chart from directly entered values.

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; object[] yValues = new object[] { 2000, 1000, 1000 }; object[] xValues = new object[] { "Total Income", "Expenses", "Profit" }; //Adding series and values IChartShape chart = sheet.Charts.Add(); IChartSerie serie = chart.Series.Add(ExcelChartType.Pie); //Enters the X and Y values directly serie.EnteredDirectlyValues = yValues; serie.EnteredDirectlyCategoryLabels = xValues; workbook.SaveAs("Chart.xlsx"); }

Using excelEngine As ExcelEngine = New ExcelEngine() Dim application As IApplication = excelEngine.Excel application.DefaultVersion = ExcelVersion.Excel2013 Dim workbook As IWorkbook = application.Workbooks.Create(1) Dim sheet As IWorksheet = workbook.Worksheets(0) Dim yValues As Object() = New Object() {2000, 1000, 1000} Dim xValues As Object() = New Object() {"Total Income", "Expenses", "Profit"} 'Adding series and values Dim chart As IChartShape = sheet.Charts.Add() Dim serie As IChartSerie = chart.Series.Add(ExcelChartType.Pie) 'Enters the X and Y values directly serie.EnteredDirectlyValues = yValues serie.EnteredDirectlyCategoryLabels = xValues workbook.SaveAs("Chart.xlsx") End Using

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; object[] yValues = new object[] { 2000, 1000, 1000 }; object[] xValues = new object[] { "Total Income", "Expenses", "Profit" }; //Adding series and values IChartShape chart = sheet.Charts.Add(); IChartSerie serie = chart.Series.Add(ExcelChartType.Pie); //Enters the X and Y values directly serie.EnteredDirectlyValues = yValues; serie.EnteredDirectlyCategoryLabels = xValues; //Initializes FileSavePicker FileSavePicker savePicker = new FileSavePicker(); savePicker.SuggestedStartLocation = PickerLocationId.Desktop; savePicker.SuggestedFileName = "Chart"; savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlsx" }); //Creates a storage file from FileSavePicker StorageFile storageFile = await savePicker.PickSaveFileAsync(); //Saves changes to the specified storage file await workbook.SaveAsAsync(storageFile); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; object[] yValues = new object[] { 2000, 1000, 1000 }; object[] xValues = new object[] { "Total Income", "Expenses", "Profit" }; //Adding series and values IChartShape chart = sheet.Charts.Add(); IChartSerie serie = chart.Series.Add(ExcelChartType.Pie); //Enters the X and Y values directly serie.EnteredDirectlyValues = yValues; serie.EnteredDirectlyCategoryLabels = xValues; //Saving the workbook as stream FileStream stream = new FileStream("Chart.xlsx", FileMode.Create, FileAccess.ReadWrite); workbook.SaveAs(stream); stream.Dispose(); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; object[] yValues = new object[] { 2000, 1000, 1000 }; object[] xValues = new object[] { "Total Income", "Expenses", "Profit" }; //Adding series and values IChartShape chart = sheet.Charts.Add(); IChartSerie serie = chart.Series.Add(ExcelChartType.Pie); //Enters the X and Y values directly serie.EnteredDirectlyValues = yValues; serie.EnteredDirectlyCategoryLabels = xValues; //Saving the workbook as stream MemoryStream stream = new MemoryStream(); workbook.SaveAs(stream); stream.Position = 0; //Save the document as file and view the saved document //The operation in SaveAndView under Xamarin varies between Windows Phone, Android and iOS platforms. Please refer xlsio/xamarin section for respective code samples. if (Device.OS == TargetPlatform.WinPhone || Device.OS == TargetPlatform.Windows) { Xamarin.Forms.DependencyService.Get<ISaveWindowsPhone>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } else { Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } }

A complete working example to create a chart from scratch in C# is present on this GitHub page.

Creating a Chart by adding Series

A chart can also be created by adding series one by one. The following code illustrates how to create a chart through series.

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Inserts the sample data for the chart sheet.Range["A1"].Text = "Month"; sheet.Range["B1"].Text = "Product A"; sheet.Range["C1"].Text = "Product B"; //Months sheet.Range["A2"].Text = "Jan"; sheet.Range["A3"].Text = "Feb"; sheet.Range["A4"].Text = "Mar"; sheet.Range["A5"].Text = "Apr"; sheet.Range["A6"].Text = "May"; //Create a random Data Random r = new Random(); for (int i = 2; i <= 6; i++) { for (int j = 2; j <= 3; j++) { sheet.Range[i, j].Number = r.Next(0, 500); } } IChartShape chart = sheet.Charts.Add(); //Set chart type chart.ChartType = ExcelChartType.Line; //Set Chart Title chart.ChartTitle = "Product Sales comparison"; //Set first serie IChartSerie productA = chart.Series.Add("ProductA"); productA.Values = sheet.Range["B2:B6"]; productA.CategoryLabels = sheet.Range["A2:A6"]; //Set second serie IChartSerie productB = chart.Series.Add("ProductB"); productB.Values = sheet.Range["C2:C6"]; productB.CategoryLabels = sheet.Range["A2:A6"]; workbook.SaveAs("Chart.xlsx"); }

Using excelEngine As ExcelEngine = New ExcelEngine() Dim application As IApplication = excelEngine.Excel application.DefaultVersion = ExcelVersion.Excel2013 Dim workbook As IWorkbook = application.Workbooks.Create(1) Dim sheet As IWorksheet = workbook.Worksheets(0) 'Inserting sample data for the chart sheet.Range("A1").Text = "Month" sheet.Range("B1").Text = "Product A" sheet.Range("C1").Text = "Product B" 'Months sheet.Range("A2").Text = "Jan" sheet.Range("A3").Text = "Feb" sheet.Range("A4").Text = "Mar" sheet.Range("A5").Text = "Apr" sheet.Range("A6").Text = "May" 'Create a random data Dim r As Random = New Random For i As Integer = 2 To 6 For j As Integer = 2 To 3 sheet.Range(i, j).Number = r.Next(0, 500) Next j Next i Dim chart As IChartShape = sheet.Charts.Add() 'Set chart type chart.ChartType = ExcelChartType.Line 'Set Chart Title chart.ChartTitle = "Product Sales comparison" 'Set first serie Dim productA As IChartSerie = chart.Series.Add("ProductA") productA.Values = sheet.Range("B2:B6") productA.CategoryLabels = sheet.Range("A2:A6") 'set second serie Dim productB As IChartSerie = chart.Series.Add("ProductB") productB.Values = sheet.Range("C2:C6") productB.CategoryLabels = sheet.Range("A2:A6") workbook.SaveAs("Chart.xlsx") End Using

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Inserts the sample data for the chart sheet.Range["A1"].Text = "Month"; sheet.Range["B1"].Text = "Product A"; sheet.Range["C1"].Text = "Product B"; //Months sheet.Range["A2"].Text = "Jan"; sheet.Range["A3"].Text = "Feb"; sheet.Range["A4"].Text = "Mar"; sheet.Range["A5"].Text = "Apr"; sheet.Range["A6"].Text = "May"; //Create a random Data Random r = new Random(); for (int i = 2; i <= 6; i++) { for (int j = 2; j <= 3; j++) { sheet.Range[i, j].Number = r.Next(0, 500); } } IChartShape chart = sheet.Charts.Add(); //Set chart type chart.ChartType = ExcelChartType.Line; //Set Chart Title chart.ChartTitle = "Product Sales comparison"; //Set first serie IChartSerie productA = chart.Series.Add("ProductA"); productA.Values = sheet.Range["B2:B6"]; productA.CategoryLabels = sheet.Range["A2:A6"]; //Set second serie IChartSerie productB = chart.Series.Add("ProductB"); productB.Values = sheet.Range["C2:C6"]; productB.CategoryLabels = sheet.Range["A2:A6"]; //Initializes FileSavePicker FileSavePicker savePicker = new FileSavePicker(); savePicker.SuggestedStartLocation = PickerLocationId.Desktop; savePicker.SuggestedFileName = "Chart"; savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlsx" }); //Creates a storage file from FileSavePicker StorageFile storageFile = await savePicker.PickSaveFileAsync(); //Saves changes to the specified storage file await workbook.SaveAsAsync(storageFile); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Inserts the sample data for the chart sheet.Range["A1"].Text = "Month"; sheet.Range["B1"].Text = "Product A"; sheet.Range["C1"].Text = "Product B"; //Months sheet.Range["A2"].Text = "Jan"; sheet.Range["A3"].Text = "Feb"; sheet.Range["A4"].Text = "Mar"; sheet.Range["A5"].Text = "Apr"; sheet.Range["A6"].Text = "May"; //Create a random Data Random r = new Random(); for (int i = 2; i <= 6; i++) { for (int j = 2; j <= 3; j++) { sheet.Range[i, j].Number = r.Next(0, 500); } } IChartShape chart = sheet.Charts.Add(); //Set chart type chart.ChartType = ExcelChartType.Line; //Set Chart Title chart.ChartTitle = "Product Sales comparison"; //Set first serie IChartSerie productA = chart.Series.Add("ProductA"); productA.Values = sheet.Range["B2:B6"]; productA.CategoryLabels = sheet.Range["A2:A6"]; //Set second serie IChartSerie productB = chart.Series.Add("ProductB"); productB.Values = sheet.Range["C2:C6"]; productB.CategoryLabels = sheet.Range["A2:A6"]; //Saving the workbook as stream FileStream stream = new FileStream("Chart.xlsx", FileMode.Create, FileAccess.ReadWrite); workbook.SaveAs(stream); stream.Dispose(); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Inserts the sample data for the chart sheet.Range["A1"].Text = "Month"; sheet.Range["B1"].Text = "Product A"; sheet.Range["C1"].Text = "Product B"; //Months sheet.Range["A2"].Text = "Jan"; sheet.Range["A3"].Text = "Feb"; sheet.Range["A4"].Text = "Mar"; sheet.Range["A5"].Text = "Apr"; sheet.Range["A6"].Text = "May"; //Create a random Data Random r = new Random(); for (int i = 2; i <= 6; i++) { for (int j = 2; j <= 3; j++) { sheet.Range[i, j].Number = r.Next(0, 500); } } IChartShape chart = sheet.Charts.Add(); //Set chart type chart.ChartType = ExcelChartType.Line; //Set Chart Title chart.ChartTitle = "Product Sales comparison"; //Set first serie IChartSerie productA = chart.Series.Add("ProductA"); productA.Values = sheet.Range["B2:B6"]; productA.CategoryLabels = sheet.Range["A2:A6"]; //Set second serie IChartSerie productB = chart.Series.Add("ProductB"); productB.Values = sheet.Range["C2:C6"]; productB.CategoryLabels = sheet.Range["A2:A6"]; //Saving the workbook as stream MemoryStream stream = new MemoryStream(); workbook.SaveAs(stream); stream.Position = 0; //Save the document as file and view the saved document //The operation in SaveAndView under Xamarin varies between Windows Phone, Android and iOS platforms. Please refer xlsio/xamarin section for respective code samples. if (Device.OS == TargetPlatform.WinPhone || Device.OS == TargetPlatform.Windows) { Xamarin.Forms.DependencyService.Get<ISaveWindowsPhone>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } else { Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } }

A complete working example to create a chart through series in C# is present on this GitHub page.

Creating a chart Sheet

The following code snippet shows how to create a chart sheet (separate sheet).

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Add the chart sheet IChart chart = workbook.Charts.Add(); chart.ChartType = ExcelChartType.Column_Clustered; chart.DataRange = sheet.Range["A1:E5"]; workbook.SaveAs("Chart.xlsx"); }

Using excelEngine As ExcelEngine = New ExcelEngine() Dim application As IApplication = excelEngine.Excel application.DefaultVersion = ExcelVersion.Excel2013 Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic) Dim sheet As IWorksheet = workbook.Worksheets(0) 'Add the chart sheet Dim chart As IChart = workbook.Charts.Add() chart.ChartType = ExcelChartType.Column_Clustered chart.DataRange = sheet.Range("A1:E5") workbook.SaveAs("Chart.xlsx") End Using

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; //Instantiates the File Picker FileOpenPicker openPicker = new FileOpenPicker(); openPicker.SuggestedStartLocation = PickerLocationId.Desktop; openPicker.FileTypeFilter.Add(".xlsx"); openPicker.FileTypeFilter.Add(".xls"); StorageFile file = await openPicker.PickSingleFileAsync(); //Opens the workbook IWorkbook workbook = await application.Workbooks.OpenAsync(file, ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Add the chart sheet IChart chart = workbook.Charts.Add(); chart.ChartType = ExcelChartType.Column_Clustered; chart.DataRange = sheet.Range["A1:E5"]; //Initializes FileSavePicker FileSavePicker savePicker = new FileSavePicker(); savePicker.SuggestedStartLocation = PickerLocationId.Desktop; savePicker.SuggestedFileName = "Chart"; savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlsx" }); //Creates a storage file from FileSavePicker StorageFile storageFile = await savePicker.PickSaveFileAsync(); //Saves changes to the specified storage file await workbook.SaveAsAsync(storageFile); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; FileStream inputStream = new FileStream("Sample.xlsx", FileMode.Open, FileAccess.Read); IWorkbook workbook = application.Workbooks.Open(inputStream, ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Add the chart sheet IChart chart = workbook.Charts.Add(); chart.ChartType = ExcelChartType.Column_Clustered; chart.DataRange = sheet.Range["A1:E5"]; //Saving the workbook as stream FileStream stream = new FileStream("Chart.xlsx", FileMode.Create, FileAccess.ReadWrite); workbook.SaveAs(stream); stream.Dispose(); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; //"App" is the class of Portable project Assembly assembly = typeof(App).GetTypeInfo().Assembly; Stream inputStream = assembly.GetManifestResourceStream("SampleBrowser.XlsIO.Samples.Template.Sample.xlsx"); IWorkbook workbook = application.Workbooks.Open(inputStream, ExcelOpenType.Automatic); IWorksheet sheet = workbook.Worksheets[0]; //Add the chart sheet IChart chart = workbook.Charts.Add(); chart.ChartType = ExcelChartType.Column_Clustered; chart.DataRange = sheet.Range["A1:E5"]; //Saving the workbook as stream MemoryStream stream = new MemoryStream(); workbook.SaveAs(stream); stream.Position = 0; //Save the document as file and view the saved document //The operation in SaveAndView under Xamarin varies between Windows Phone, Android and iOS platforms. Please refer xlsio/xamarin section for respective code samples. if (Device.OS == TargetPlatform.WinPhone || Device.OS == TargetPlatform.Windows) { Xamarin.Forms.DependencyService.Get<ISaveWindowsPhone>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } else { Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } }

A complete working example to create a chart worksheet in C# is present on this GitHub page.

Creating Custom Charts 

A custom chart can be created by using different types of charts for different data series.

For example, you can use a column chart for the first data series and a line chart for the second series. As a result you will have a column chart, combined with a line chart.

This sample also explains different chart properties like

Set Data Range to Chart

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

//Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"];

'Add a new chart with data range Dim chart As IChartShape = sheet.Charts.Add() chart.DataRange = sheet.Range("A3:C6")

//Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"];

//Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"];

//Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"];

Name the Chart and Set Chart Title

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

//Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA";

'Set chart name and chart title chart.Name = "CrescentCity,CA" chart.ChartTitle = "Crescent City, CA"

//Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA";

//Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA";

//Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA";

Different Primary Value Axis Properties

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

//Axis title chart.PrimaryValueAxis.Title = "Precipitation,in."; //Axis title area text angle rotation chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; //Maximum value in the axis chart.PrimaryValueAxis.MaximumValue = 14.0; //Number format for axis chart.PrimaryValueAxis.NumberFormat = "0.0";

'Axis title chart.PrimaryValueAxis.Title = "Precipitation,in." 'Axis title area text angle rotation chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90 'Maximum value in the axis chart.PrimaryValueAxis.MaximumValue = 14.0 'Number format for axis chart.PrimaryValueAxis.NumberFormat = "0.0"

//Axis title chart.PrimaryValueAxis.Title = "Precipitation,in."; //Axis title area text angle rotation chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; //Maximum value in the axis chart.PrimaryValueAxis.MaximumValue = 14.0; //Number format for axis chart.PrimaryValueAxis.NumberFormat = "0.0";

//Axis title chart.PrimaryValueAxis.Title = "Precipitation,in."; //Axis title area text angle rotation chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; //Maximum value in the axis chart.PrimaryValueAxis.MaximumValue = 14.0; //Number format for axis chart.PrimaryValueAxis.NumberFormat = "0.0";

//Axis title chart.PrimaryValueAxis.Title = "Precipitation,in."; //Axis title area text angle rotation chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; //Maximum value in the axis chart.PrimaryValueAxis.MaximumValue = 14.0; //Number format for axis chart.PrimaryValueAxis.NumberFormat = "0.0";

Different Secondary Value Axis Properties

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

//MaxCross in axis chart.SecondaryValueAxis.IsMaxCross = true; //Axis title chart.SecondaryValueAxis.Title = "Temperature,deg.F"; //Axis title area text angle rotation chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90;

'MaxCross in axis chart.SecondaryValueAxis.IsMaxCross = true 'Axis title chart.SecondaryValueAxis.Title = "Temperature,deg.F" 'Axis title area text angle rotation chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90

//MaxCross in axis chart.SecondaryValueAxis.IsMaxCross = true; //Axis title chart.SecondaryValueAxis.Title = "Temperature,deg.F"; //Axis title area text angle rotation chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90;

//MaxCross in axis chart.SecondaryValueAxis.IsMaxCross = true; //Axis title chart.SecondaryValueAxis.Title = "Temperature,deg.F"; //Axis title area text angle rotation chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90;

//MaxCross in axis chart.SecondaryValueAxis.IsMaxCross = true; //Axis title chart.SecondaryValueAxis.Title = "Temperature,deg.F"; //Axis title area text angle rotation chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90;

Different Secondary Category Axis Properties

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

//MaxCross in axis chart.SecondaryCategoryAxis.IsMaxCross = true; //Select border line color chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent; //Select major tick mark option chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; //Select tick label position chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None;

'MaxCross in axis chart.SecondaryCategoryAxis.IsMaxCross = true 'Select border line color chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent 'Select major tick mark option chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None 'Select tick label position chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None

//MaxCross in axis chart.SecondaryCategoryAxis.IsMaxCross = true; //Select border line color chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent; //Select major tick mark option chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; //Select tick label position chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None;

//MaxCross in axis chart.SecondaryCategoryAxis.IsMaxCross = true; //Select border line color chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent; //Select major tick mark option chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; //Select tick label position chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None;

//MaxCross in axis chart.SecondaryCategoryAxis.IsMaxCross = true; //Select border line color chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent; //Select major tick mark option chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; //Select tick label position chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None;

Different Chart Series Fill Properties

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

IChartSerie serieOne = chart.Series[0]; //Series name serieOne.Name = "Precipitation,in."; //Series fill type serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; //Series two color gradient serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); //Series gradient color type serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; //Series fore color serieOne.SerieFormat.Fill.ForeColor = Color.Plum;

Dim serieOne As IChartSerie = chart.Series(0) 'Series name serieOne.Name = "Precipitation,in." 'Series fill type serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient 'Series two color gradient serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2) 'Series gradient color type serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor 'Series fore color serieOne.SerieFormat.Fill.ForeColor = Color.Plum

IChartSerie serieOne = chart.Series[0]; //Series name serieOne.Name = "Precipitation,in."; //Series fill type serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; //Series two color gradient serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); //Series gradient color type serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; //Series fore color serieOne.SerieFormat.Fill.ForeColor = Color.Plum;

IChartSerie serieOne = chart.Series[0]; //Series name serieOne.Name = "Precipitation,in."; //Series fill type serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; //Series two color gradient serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); //Series gradient color type serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; //Series fore color serieOne.SerieFormat.Fill.ForeColor = Color.Plum;

IChartSerie serieOne = chart.Series[0]; //Series name serieOne.Name = "Precipitation,in."; //Series fill type serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; //Series two color gradient serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); //Series gradient color type serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; //Series fore color serieOne.SerieFormat.Fill.ForeColor = Color.Plum;

Different Marker Properties

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

IChartSerie serieTwo = chart.Series[1]; //Marker style serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; //Marker size serieTwo.SerieFormat.MarkerSize = 8; //Marker background color serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen; //Marker foreground color serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen;

Dim serieTwo As IChartSerie = chart.Series(1) 'Marker style serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond 'Marker size serieTwo.SerieFormat.MarkerSize = 8 'Marker background color serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen 'Marker foreground color serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen

IChartSerie serieTwo = chart.Series[1]; //Marker style serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; //Marker size serieTwo.SerieFormat.MarkerSize = 8; //Marker background color serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen; //Marker foreground color serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen;

IChartSerie serieTwo = chart.Series[1]; //Marker style serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; //Marker size serieTwo.SerieFormat.MarkerSize = 8; //Marker background color serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen; //Marker foreground color serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen;

IChartSerie serieTwo = chart.Series[1]; //Marker style serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; //Marker size serieTwo.SerieFormat.MarkerSize = 8; //Marker background color serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen; //Marker foreground color serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen;

Different Legend Properties

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

//Legend without overlapping the chart chart.Legend.IncludeInLayout = true; //Legend position chart.Legend.Position = ExcelLegendPosition.Bottom; //View legend horizontally chart.Legend.IsVerticalLegend = false;

'Legend without overlapping the chart chart.Legend.IncludeInLayout = true 'Legend position chart.Legend.Position = ExcelLegendPosition.Bottom 'View legend horizontally chart.Legend.IsVerticalLegend = false

//Legend without overlapping the chart chart.Legend.IncludeInLayout = true; //Legend position chart.Legend.Position = ExcelLegendPosition.Bottom; //View legend horizontally chart.Legend.IsVerticalLegend = false;

//Legend without overlapping the chart chart.Legend.IncludeInLayout = true; //Legend position chart.Legend.Position = ExcelLegendPosition.Bottom; //View legend horizontally chart.Legend.IsVerticalLegend = false;

//Legend without overlapping the chart chart.Legend.IncludeInLayout = true; //Legend position chart.Legend.Position = ExcelLegendPosition.Bottom; //View legend horizontally chart.Legend.IsVerticalLegend = false;

The complete code snippet illustrating the above options along with creating custom charts is shown below.

• C#
• VB.NET
• UWP
• ASP.NET Core
• Xamarin

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Merge cells sheet.Range["A1:D1"].Merge(); //Set Font style as bold sheet.Range["A1"].CellStyle.Font.Bold = true; //Insert data for the chart sheet.Range["A1"].Text = "Crescent City, CA"; sheet.Range["B3"].Text = "Precipitation,in."; sheet.Range["C3"].Text = "Temperature,deg.F"; sheet.Range["A4"].Text = "Jan"; sheet.Range["A5"].Text = "Feb"; sheet.Range["A6"].Text = "March"; sheet.Range["B4"].Number = 10.9; sheet.Range["B5"].Number = 8.9; sheet.Range["B6"].Number = 8.6; sheet.Range["C4"].Number = 47.5; sheet.Range["C5"].Number = 48.7; sheet.Range["C6"].Number = 48.9; //Adjust column width in used range sheet.UsedRange.AutofitColumns(); //Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"]; //Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA"; chart.IsSeriesInRows = false; //Set primary value axis properties chart.PrimaryValueAxis.Title = "Precipitation,in."; chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; chart.PrimaryValueAxis.MaximumValue = 14.0; chart.PrimaryValueAxis.NumberFormat = "0.0"; //Format first serie fill properties IChartSerie serieOne = chart.Series[0]; serieOne.Name = "Precipitation,in."; serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; serieOne.SerieFormat.Fill.ForeColor = Color.Plum; //Format second serie properties IChartSerie serieTwo = chart.Series[1]; serieTwo.SerieType = ExcelChartType.Line_Markers; serieTwo.Name = "Temperature,deg.F"; //Format marker properties serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; serieTwo.SerieFormat.MarkerSize = 8; serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen; serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen; serieTwo.SerieFormat.LineProperties.LineColor = Color.DarkGreen; //Use Secondary Axis serieTwo.UsePrimaryAxis = false; //MaxCross for secondary axes chart.SecondaryCategoryAxis.IsMaxCross = true; chart.SecondaryValueAxis.IsMaxCross = true; //Set title for secondary value axis chart.SecondaryValueAxis.Title = "Temperature,deg.F"; chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90; //Set secondary category axis properties chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent; chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None; //Set legend properties chart.Legend.Position = ExcelLegendPosition.Bottom; chart.Legend.IsVerticalLegend = false; workbook.SaveAs("Chart.xlsx"); }

Dim excelEngine As New ExcelEngine() Using excelEngine As ExcelEngine = New ExcelEngine() Dim application As IApplication = excelEngine.Excel application.DefaultVersion = ExcelVersion.Excel2013 Dim workbook As IWorkbook = application.Workbooks.Create(1) Dim sheet As IWorksheet = workbook.Worksheets(0) 'Merge cells sheet.Range("A1:D1").Merge() 'Set Font style as bold sheet.Range("A1").CellStyle.Font.Bold = True 'Insert data for the chart sheet.Range("A1").Text = "Crescent City, CA" sheet.Range("B3").Text = "Precipitation,in." sheet.Range("C3").Text = "Temperature,deg.F" sheet.Range("A4").Text = "Jan" sheet.Range("A5").Text = "Feb" sheet.Range("A6").Text = "March" sheet.Range("B4").Number = 10.9 sheet.Range("B5").Number = 8.9 sheet.Range("B6").Number = 8.6 sheet.Range("C4").Number = 47.5 sheet.Range("C5").Number = 48.7 sheet.Range("C6").Number = 48.9 'Adjust column width in used range sheet.UsedRange.AutofitColumns() 'Add a new chart with data range Dim chart As IChartShape = sheet.Charts.Add() chart.DataRange = sheet.Range("A3:C6") 'Set chart name and chart title chart.Name = "CrescentCity,CA" chart.ChartTitle = "Crescent City, CA" chart.IsSeriesInRows = False 'Set primary value axis properties chart.PrimaryValueAxis.Title = "Precipitation,in." chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90 chart.PrimaryValueAxis.MaximumValue = 14.0 chart.PrimaryValueAxis.NumberFormat = "0.0" 'Format first serie fill properties Dim serieOne As IChartSerie = chart.Series(0) serieOne.Name = "Precipitation,in." serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2) serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor serieOne.SerieFormat.Fill.ForeColor = Color.Plum 'Format second serie properties Dim serieTwo As IChartSerie = chart.Series(1) serieTwo.SerieType = ExcelChartType.Line_Markers serieTwo.Name = "Temperature,deg.F" 'Format marker properties serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond serieTwo.SerieFormat.MarkerSize = 8 serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen serieTwo.SerieFormat.LineProperties.LineColor = Color.DarkGreen 'Use Secondary Axis serieTwo.UsePrimaryAxis = False 'MaxCross for secondary axes chart.SecondaryCategoryAxis.IsMaxCross = True chart.SecondaryValueAxis.IsMaxCross = True 'Set title for secondary value axis chart.SecondaryValueAxis.Title = "Temperature,deg.F" chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90 'Set secondary category axis properties chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None 'Set legend properties chart.Legend.Position = ExcelLegendPosition.Bottom chart.Legend.IsVerticalLegend = False workbook.SaveAs("Chart.xlsx") End Using

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Merge cells sheet.Range["A1:D1"].Merge(); //Set Font style as bold sheet.Range["A1"].CellStyle.Font.Bold = true; //Insert data for the chart sheet.Range["A1"].Text = "Crescent City, CA"; sheet.Range["B3"].Text = "Precipitation,in."; sheet.Range["C3"].Text = "Temperature,deg.F"; sheet.Range["A4"].Text = "Jan"; sheet.Range["A5"].Text = "Feb"; sheet.Range["A6"].Text = "March"; sheet.Range["B4"].Number = 10.9; sheet.Range["B5"].Number = 8.9; sheet.Range["B6"].Number = 8.6; sheet.Range["C4"].Number = 47.5; sheet.Range["C5"].Number = 48.7; sheet.Range["C6"].Number = 48.9; //Adjust column width in used range sheet.UsedRange.AutofitColumns(); //Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"]; //Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA"; chart.IsSeriesInRows = false; //Set primary value axis properties chart.PrimaryValueAxis.Title = "Precipitation,in."; chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; chart.PrimaryValueAxis.MaximumValue = 14.0; chart.PrimaryValueAxis.NumberFormat = "0.0"; //Format first serie fill properties IChartSerie serieOne = chart.Series[0]; serieOne.Name = "Precipitation,in."; serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; serieOne.SerieFormat.Fill.ForeColor = Color.FromArgb(255, 221, 160, 221); //Format second serie properties IChartSerie serieTwo = chart.Series[1]; serieTwo.SerieType = ExcelChartType.Line_Markers; serieTwo.Name = "Temperature,deg.F"; //Format marker properties serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; serieTwo.SerieFormat.MarkerSize = 8; serieTwo.SerieFormat.MarkerBackgroundColor = Color.FromArgb(255, 0, 100, 0); serieTwo.SerieFormat.MarkerForegroundColor = Color.FromArgb(255, 0, 100, 0); serieTwo.SerieFormat.LineProperties.LineColor = Color.FromArgb(255, 0, 100, 0); //Use Secondary Axis serieTwo.UsePrimaryAxis = false; //MaxCross for secondary axes chart.SecondaryCategoryAxis.IsMaxCross = true; chart.SecondaryValueAxis.IsMaxCross = true; //Set title for secondary value axis chart.SecondaryValueAxis.Title = "Temperature,deg.F"; chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90; //Set secondary category axis properties chart.SecondaryCategoryAxis.Border.LineColor = Color.FromArgb(0, 255, 255, 255); chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None; //Set legend properties chart.Legend.Position = ExcelLegendPosition.Bottom; chart.Legend.IsVerticalLegend = false; //Initializes FileSavePicker FileSavePicker savePicker = new FileSavePicker(); savePicker.SuggestedStartLocation = PickerLocationId.Desktop; savePicker.SuggestedFileName = "Chart"; savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlsx" }); //Creates a storage file from FileSavePicker StorageFile storageFile = await savePicker.PickSaveFileAsync(); //Saves changes to the specified storage file await workbook.SaveAsAsync(storageFile); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Merge cells sheet.Range["A1:D1"].Merge(); //Set Font style as bold sheet.Range["A1"].CellStyle.Font.Bold = true; //Insert data for the chart sheet.Range["A1"].Text = "Crescent City, CA"; sheet.Range["B3"].Text = "Precipitation,in."; sheet.Range["C3"].Text = "Temperature,deg.F"; sheet.Range["A4"].Text = "Jan"; sheet.Range["A5"].Text = "Feb"; sheet.Range["A6"].Text = "March"; sheet.Range["B4"].Number = 10.9; sheet.Range["B5"].Number = 8.9; sheet.Range["B6"].Number = 8.6; sheet.Range["C4"].Number = 47.5; sheet.Range["C5"].Number = 48.7; sheet.Range["C6"].Number = 48.9; //Adjust column width in used range sheet.UsedRange.AutofitColumns(); //Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"]; //Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA"; chart.IsSeriesInRows = false; //Set primary value axis properties chart.PrimaryValueAxis.Title = "Precipitation,in."; chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; chart.PrimaryValueAxis.MaximumValue = 14.0; chart.PrimaryValueAxis.NumberFormat = "0.0"; //Format first serie fill properties IChartSerie serieOne = chart.Series[0]; serieOne.Name = "Precipitation,in."; serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; serieOne.SerieFormat.Fill.ForeColor = Color.Plum; //Format second serie properties IChartSerie serieTwo = chart.Series[1]; serieTwo.SerieType = ExcelChartType.Line_Markers; serieTwo.Name = "Temperature,deg.F"; //Format marker properties serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; serieTwo.SerieFormat.MarkerSize = 8; serieTwo.SerieFormat.MarkerBackgroundColor = Color.DarkGreen; serieTwo.SerieFormat.MarkerForegroundColor = Color.DarkGreen; serieTwo.SerieFormat.LineProperties.LineColor = Color.DarkGreen; //Use Secondary Axis serieTwo.UsePrimaryAxis = false; //MaxCross for secondary axes chart.SecondaryCategoryAxis.IsMaxCross = true; chart.SecondaryValueAxis.IsMaxCross = true; //Set title for secondary value axis chart.SecondaryValueAxis.Title = "Temperature,deg.F"; chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90; //Set secondary category axis properties chart.SecondaryCategoryAxis.Border.LineColor = Color.Transparent; chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None; //Set legend properties chart.Legend.Position = ExcelLegendPosition.Bottom; chart.Legend.IsVerticalLegend = false; //Saving the workbook as stream FileStream stream = new FileStream("Chart.xlsx", FileMode.Create, FileAccess.ReadWrite); workbook.SaveAs(stream); stream.Dispose(); }

using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Merge cells sheet.Range["A1:D1"].Merge(); //Set Font style as bold sheet.Range["A1"].CellStyle.Font.Bold = true; //Insert data for the chart sheet.Range["A1"].Text = "Crescent City, CA"; sheet.Range["B3"].Text = "Precipitation,in."; sheet.Range["C3"].Text = "Temperature,deg.F"; sheet.Range["A4"].Text = "Jan"; sheet.Range["A5"].Text = "Feb"; sheet.Range["A6"].Text = "March"; sheet.Range["B4"].Number = 10.9; sheet.Range["B5"].Number = 8.9; sheet.Range["B6"].Number = 8.6; sheet.Range["C4"].Number = 47.5; sheet.Range["C5"].Number = 48.7; sheet.Range["C6"].Number = 48.9; //Adjust column width in used range sheet.UsedRange.AutofitColumns(); //Add a new chart with data range IChartShape chart = sheet.Charts.Add(); chart.DataRange = sheet.Range["A3:C6"]; //Set chart name and chart title chart.Name = "CrescentCity,CA"; chart.ChartTitle = "Crescent City, CA"; chart.IsSeriesInRows = false; //Set primary value axis properties chart.PrimaryValueAxis.Title = "Precipitation,in."; chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; chart.PrimaryValueAxis.MaximumValue = 14.0; chart.PrimaryValueAxis.NumberFormat = "0.0"; //Format first serie fill properties IChartSerie serieOne = chart.Series[0]; serieOne.Name = "Precipitation,in."; serieOne.SerieFormat.Fill.FillType = ExcelFillType.Gradient; serieOne.SerieFormat.Fill.TwoColorGradient(ExcelGradientStyle.Vertical, ExcelGradientVariants.ShadingVariants_2); serieOne.SerieFormat.Fill.GradientColorType = ExcelGradientColor.TwoColor; serieOne.SerieFormat.Fill.ForeColor = Syncfusion.Drawing.Color.Plum; //Format second serie properties IChartSerie serieTwo = chart.Series[1]; serieTwo.SerieType = ExcelChartType.Line_Markers; serieTwo.Name = "Temperature,deg.F"; //Format marker properties serieTwo.SerieFormat.MarkerStyle = ExcelChartMarkerType.Diamond; serieTwo.SerieFormat.MarkerSize = 8; serieTwo.SerieFormat.MarkerBackgroundColor = Syncfusion.Drawing.Color.DarkGreen; serieTwo.SerieFormat.MarkerForegroundColor = Syncfusion.Drawing.Color.DarkGreen; serieTwo.SerieFormat.LineProperties.LineColor = Syncfusion.Drawing.Color.DarkGreen; //Use Secondary Axis serieTwo.UsePrimaryAxis = false; //MaxCross for secondary axes chart.SecondaryCategoryAxis.IsMaxCross = true; chart.SecondaryValueAxis.IsMaxCross = true; //Set title for secondary value axis chart.SecondaryValueAxis.Title = "Temperature,deg.F"; chart.SecondaryValueAxis.TitleArea.TextRotationAngle = 90; //Set secondary category axis properties chart.SecondaryCategoryAxis.Border.LineColor = Syncfusion.Drawing.Color.Transparent; chart.SecondaryCategoryAxis.MajorTickMark = ExcelTickMark.TickMark_None; chart.SecondaryCategoryAxis.TickLabelPosition = ExcelTickLabelPosition.TickLabelPosition_None; //Set legend properties chart.Legend.Position = ExcelLegendPosition.Bottom; chart.Legend.IsVerticalLegend = false; //Saving the workbook as stream MemoryStream stream = new MemoryStream(); workbook.SaveAs(stream); stream.Position = 0; //Save the document as file and view the saved document //The operation in SaveAndView under Xamarin varies between Windows Phone, Android and iOS platforms. Please refer xlsio/xamarin section for respective code samples. if (Device.OS == TargetPlatform.WinPhone || Device.OS == TargetPlatform.Windows) { Xamarin.Forms.DependencyService.Get<ISaveWindowsPhone>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } else { Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("Chart.xlsx", "application/msexcel", stream); } }