Articles in this section
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:

Add_Chart.zip

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment