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.
Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us