I can create a chart is aspose cells however I read that the datatable can not be added this way so I created a chart in the original excel file and then try to call it using:
Dim chart13 As Chart = workbook.Worksheets(10).Charts(0)
However I am receiving an error :
7System.ArgumentOutOfRangeException: Index was out of range
I am manipulating the entire workbood and this is the last worksheet. I know the indexes are correct as I fill the worksheet with data using them and this is the only chart created on teh page.
Can I manually create a chart and then manipulate it using Aspose.Cells? Or am I doing something else incorrectly.