I am having the data series more than 255 rows.When i am try to add the series into chart i am getting the error “com.aspose.cells.CellsException: The number of series could not exceed 256”. Please find the attachment for your reference.Let me know in case of any queries.
Hi,
Thanks for providing us screenshot and details.
Well, this is a limitation put forth by MS Excel and nothing to do with Aspose.Cells APIs, you cannot add/ have more than 255 data series for a chart, see the document (on MS Excel limits) for your reference:
Aspose.Cells follows MS Excel standards and specifications in creating or rendering charts, so I am afraid, you cannot add series more than 255. If you still think this can be done in MS Excel, kindly do provide an Excel file that contains a chart with more than 255 data series for a chart, save the Excel file manually in MS Excel and provide us here, we will check how to do it via Aspose.Cells APIs.
Thank you.