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: