|
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:
|
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
