Essential XlsIO

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?


3 Replies

CL clement January 14, 2008 07:28 AM UTC

the attachment is a sample what the excel looks like



chart.zip


CL clement January 14, 2008 07:57 AM UTC

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'.









YG Yavanaarasi G Syncfusion Team January 17, 2008 10:27 AM UTC

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




Loader.
Up arrow icon