We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose Cells for Chart

Shall I use two workbooks one for showing the records in cells and another for displaying the chart in a same worksheet.

Hi,

Well, I am not clear about your query, could elaborate it more, so that we can understand it completely.

When you create charts in an excel file, it's up to you to decide whether you want two worksheets in a workbook i.e.., one for data source and other for displaying charts. You can also fill the data into different cells (as source data) and create the chart in the same worksheet for your need. Aspose.Cells for .NET provide the complete feasibility for the users, e.g..,

//Add a chart sheet.

int sheetIndex = workbook.Worksheets.Add(SheetType.Chart);

//Add a simple sheet.

int sheetIndex = workbook.Worksheets.Add(SheetType.Worksheet);

Thank you.

Hi Amjad. Thank you very much for your suggestion.

chart.NSeries.Add("Data!A2,Data!A4,Data!A7,Data!A11,Data!A20", true);

It works fine. Thanks a lot.