We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Essential XlsIO

Thread ID:

Created:

Updated:

Platform:

Replies:

71055 Jan 14,2008 02:26 AM Jan 17,2008 05:27 AM Windows Forms 3
loading
Tags: XlsIO
clement
Asked On January 14, 2008 02:26 AM

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
Replied On January 14, 2008 02:28 AM

the attachment is a sample what the excel looks like



chart.zip

clement
Replied On January 14, 2008 02:57 AM

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 [Syncfusion]
Replied On January 17, 2008 05:27 AM

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




CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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.

;