combined Charts

[Kai Wachter]

In Excel it is possible to assign for dataseries a separate chartype than for the whole chart eg. the whole chart is AREA chart and Series 2 is a line.

but the Interface iChartSeries has no property for assigning the different chart type.

Is this possible with your engine?

best regards,

Kai

[Melba Winshia]

Hi kai,

Thank you for your interest in Essential XlsIO. Yes, it is possible to assign a seperate chart type for dataseries. Use the following code to set seperate chart type for dataseries.


[C#]

//Line Series type
serieOne.SerieType=ExcelChartType.Line;

[VB]

''Line Series type
serieOne.SerieType=ExcelChartType.Line


Here is a sample for your reference:

ChartType

Please take a look at the sample above and let me know if you have any questions.

Regards,
Melba

[Kai Wachter]

Thanks Melba for your fast response.

Is it possible to format the series also (Linecolor, backgraound color, Fillpattern etc)?

best regards,

Kai

>Hi kai,

Thank you for your interest in Essential XlsIO. Yes, it is possible to assign a seperate chart type for dataseries. Use the following code to set seperate chart type for dataseries.


[C#]

//Line Series type
serieOne.SerieType=ExcelChartType.Line;

[VB]

''Line Series type
serieOne.SerieType=ExcelChartType.Line


Here is a sample for your reference:

ChartType

Please take a look at the sample above and let me know if you have any questions.

Regards,
Melba

[Melba Winshia]

Hi Kai,

Thank you for your interest in Essential XlsIO. Yes it is possible to format the series also. Use the following code snippets to set line color, background color and fill pattern.

[C#]

//setting Line Color.
serietwo.SerieFormat.SerieDataFormat.LineProperties.LineColor=System.Drawing.Color.IndianRed;

//setting Back ground color.
serietwo.SerieFormat.SerieDataFormat.AreaProperties.BackgroundColorIndex=ExcelKnownColors.Pale_blue;

//Fill pattern
serietwo.SerieFormat.SerieDataFormat.AreaProperties.Pattern=ExcelPattern.ForwardDiagonal;

[VB]

''setting Line Color.
serietwo.SerieFormat.SerieDataFormat.LineProperties.LineColor=System.Drawing.Color.IndianRed

''setting Back ground color.
serietwo.SerieFormat.SerieDataFormat.AreaProperties.BackgroundColorIndex=ExcelKnownColors.Pale_blue

''Fill pattern.
serietwo.SerieFormat.SerieDataFormat.AreaProperties.Pattern=ExcelPattern.ForwardDiagonal
Here is a sample for your reference:

chart_color.zip

Please take a look at the sample above and let me know if you have any questions.

Regards,
Melba

[Kai Wachter]

Hi Melba,

but this does not work for 3d charts. If the general Chart type is column_stacked_3d and you make one series to Line_3d the whole chart is Line_3d.

best regards,

Kai

>Hi Kai,

Thank you for your interest in Essential XlsIO. Yes it is possible to format the series also. Use the following code snippets to set line color, background color and fill pattern.

[C#]

//setting Line Color.
serietwo.SerieFormat.SerieDataFormat.LineProperties.LineColor=System.Drawing.Color.IndianRed;

//setting Back ground color.
serietwo.SerieFormat.SerieDataFormat.AreaProperties.BackgroundColorIndex=ExcelKnownColors.Pale_blue;

//Fill pattern
serietwo.SerieFormat.SerieDataFormat.AreaProperties.Pattern=ExcelPattern.ForwardDiagonal;

[VB]

''setting Line Color.
serietwo.SerieFormat.SerieDataFormat.LineProperties.LineColor=System.Drawing.Color.IndianRed

''setting Back ground color.
serietwo.SerieFormat.SerieDataFormat.AreaProperties.BackgroundColorIndex=ExcelKnownColors.Pale_blue

''Fill pattern.
serietwo.SerieFormat.SerieDataFormat.AreaProperties.Pattern=ExcelPattern.ForwardDiagonal
Here is a sample for your reference:

chart_color.zip

Please take a look at the sample above and let me know if you have any questions.

Regards,
Melba

[Melba Winshia]

Hi Kai,

Excel does not support 3D combination charts.Can you please refer to this link.

Please let me know if you have any other questions.

Regards,
Melba

[Melba Winshia]

Hi Kai,

Excel does not support 3D combination charts.Can you please refer to this link.

http://www.bettersolutions.com/excel/EXX823/QN620422111.htm


Please let me know if you have any other questions.

Regards,
Melba

[Administrator]

Hi Melba,

thanks for your reply. But i found another problemm where you can guide me through.

When i set the Areapattern of a series, it is automatically applied to all series, even also when i reset it for the other series. All series have the same areapattern. Is this a problem of my implementation or a bug

best regards,

Kai
>Hi Kai,

Excel does not support 3D combination charts.Can you please refer to this link.

http://www.bettersolutions.com/excel/EXX823/QN620422111.htm


Please let me know if you have any other questions.

Regards,
Melba

[Melba Winshia]

Hi kai,

Use the following code snippet to format particular series.

[C#]

// Setting pattern.
serietwo.DataPoints.DefaultDataPoint.DataFormat.AreaProperties.Pattern=ExcelPattern.LightUpwardDiagonal;

Here is a sample for your reference:

chart_pattern.zip

Please take a look at the sample above and let me know if you have any questions.

Regards,
Melba