Learn how to add line chart with Aspose.Cells

In this tutorial, we'll add line chart in a excel file.

We'll start by creating a new workbook using the Aspose.Cells library and add line chart.

Unlock the playground and run code in your browser.

Copy

//ExSummary: Please check the following code to find out how to add line chart.
//ExStepSummary:0: The following code shows how to add line chart, set series data range and set category data range.
//ExStepImage:0:step-1.png
//ExStepSummary:1: The following code shows how to move the legend to bottom and set font color of the legend.
//ExStepImage:1:step-2.png
//ExStepSummary:2: The following code shows how to access data labels, turn on category names and set position.
//ExStepImage:2:step-3.png
//ExStart
//ExStep:0-
using Aspose.Cells;
using Aspose.Cells.Drawing;

Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.Name = "ChartSheet";
Cells cells = sheet.Cells;
cells["A1"].Value = "Fruit";
cells["A2"].Value = "apple";
cells["A3"].Value = "orange";
cells["A4"].Value = "blueberry";
cells["A5"].Value = "kiwi";

cells["B1"].Value = "Price";
cells["B2"].Value = 10;
cells["B3"].Value = 5;
cells["B4"].Value = 20;
cells["B5"].Value = 8;

sheet.PageSetup.PrintGridlines = true;
sheet.PageSetup.PrintArea = "A1:F20";

ChartCollection charts = sheet.Charts;

//Add line chart, set series data range and set category data range
int index = sheet.Charts.Add(ChartType.Line, 6, 0, 19, 5);
Chart chart = sheet.Charts[index];
chart.NSeries.Add("B2:B5", true);
chart.NSeries.CategoryData = "A2:A5";

//ExStep:1-
//Move the legend to bottom and set font color of the legend
chart.Legend.Font.Color = Color.Blue;
chart.Legend.Position = LegendPositionType.Bottom;

//ExStep:2-
//Access data labels, turn on category names and set position
DataLabels dataLabels = chart.NSeries[0].DataLabels;
dataLabels.ShowCategoryName = true;
dataLabels.Position = LabelPositionType.Center;

//ExStep:0-

//ExEnd

OUTPUT:

Initializing View...

Step/Step

Go Top