Category / Section
How do I draw a chart using points?
1 min read
Using XlsIO, without using range object, you can create chart by adding points to the series. This can be done as illustrated in the below code snippets:
C#
// Add a chart to the worksheet IChartShape chart = sheet.Charts.Add(); // Create a series for the chart IChartSerie serie = chart.Series.Add(); // Enter the values serie.EnteredDirectlyValues = new object[] { 17, 36, 72, 25, 62 };
VB
' Add a chart to the worksheet Dim chart As IChartShape = sheet.Charts.Add() ' Create a series for the chart Dim serie As IChartSerie = chart.Series.Add() ' Enter the values serie.EnteredDirectlyValues = New Object() {17, 36, 72, 25, 62}
Here is the sample for your reference: