Setting ChartType to Cylinder_Clustered exception

[Julian Bercovici]

Hie,

when i try to set the ChartType to Cylinder_Clustered i get the following exception:

"Specified argument was out of the range of valid values.
Parameter name: iOrder"

Could some one tell me what I'm doing wrong ?

I've added a screen shot.

Thanks.



Cylinder_Clustered_6381f6d1.jpg

[Vijesh Narayanan]

Hi Iulian,

Thank you for using Essential XlsIO.

The exception that you are mentioning is thrown if you include DataRange after specifying the chart type. The cylindrical_clustered chart type can be included into your application as specified in the following code snippet.

   IChartShape chart = sheet.Charts.Add();
   chart.DataRange = sheet.Range["B4:D10"];
   chart.ChartType = ExcelChartType.Cylinder_Clustered;

Please let me know if I could be of any further assistance.

Regards,
Vijesh