Essential XlsIO

[clement]

I would like to create to series in the a Worksheet, two series have different 'charttype'.

seriesOne is ExcelChartType.Column_Clustered.
SeriesTwo is ExcelChartType.Scatter_Line.

But I cannot create two different charttype in excel file, why?

[clement]

the attachment is a sample what the excel looks like



chart.zip

[clement]

I found a sample code:

//Setting the Serie Names in a Legend
IChartSerie serieOne = shape.Series[0];
serieOne.Name = "Jan";
IChartSerie serietwo = shape.Series[1];
serietwo.Name = "Feb";

//setting different serie type
serietwo.SerieType=ExcelChartType.Line;
IChartSerie seriethree = shape.Series[2];
seriethree.Name = "March";

But there is a error

Error:
'Syncfusion.XlsIO.IChartSerie' does not contain a definition for 'SerieType' C:\shared\chart\CS\Form1.cs 184 13 chart

May I know the reason? Should I update to which version? My version is 'Essential Studio 4.1.0.56'.

[Yavanaarasi G]

Hi Clement,

Error in definition of SerieType:

Many new features for chart has been added only from version 4.2. So please upgrade to our latest version. You can download our latest version from the below link:

http://www.syncfusion.com/downloads/latestversion/default.aspx


Here is the sample for your reference to create series with different chart types:

http://websamples.syncfusion.com/samples/XlsIO.Windows/71055/main.htm


Please let me know if you have any other queries.

Regards,
Yavana.G