Hello, I have an array with data that results from the calculation of a complex function.

VB Code:
  1. Dim szFunction() As Double

  2. szFunction = myComplexFunction(x, y)

I was using a MSChart but it seems to get messed up because it won't show the numbers (Because all the values inside of szFunction are less than 1 and greater than 0)

So I came across the ChartSpace (This is a work for school and the professor has VB and Office installed so I don't have to distribute it) and I think it could solve my problem using the Line as I want it to do it...

The problem here is that it takes the data from a recordset (or something like that) and I can't transform my array to a recordset (I haven't found a way)....

Questions:
1.- Can I insert a sheet of Excel, make it graph it and then pass it to my application?
2.- Can I pass my array as the data for the graph?
3.- Is there a way to do this?

Thanks in advance.