rlecjr
April 17th, 2001, 11:14 AM
I am populating an array and passing the data to the .chartdata property of an MSChart control. I am having a bit of trouble plotting things from the array at this point because I am not sure how the array property populates itself when I set it to my array.
There is a sample program from Microsoft called chrtsamp.vbp. This program creates an array from an excel spreadsheet and populates the control with the array. When I try this the .chartdata property receives the data differently. Does anyone know why this is? Here's the example:
ChrtSamp:
1. Populates myarray
2. chart.chartdata = myarray
3. at this point myarray(1,1) = chart.ChartData(1,0); myarray(2,1) = chart.Chartdata(2,0) and so on....
MyCODE:
1. Populates myarray
2. chart.chartdata = myarray
3. at this point myarray(1,1) = chart.ChartData(0,1); myarray(2,1) = chart.Chartdata(1,1) and so on....
I know it is a confusing question, but that just about sums it up for me. I am having a very difficult time charting these data points!
Thanks for ANY help,
Ron
There is a sample program from Microsoft called chrtsamp.vbp. This program creates an array from an excel spreadsheet and populates the control with the array. When I try this the .chartdata property receives the data differently. Does anyone know why this is? Here's the example:
ChrtSamp:
1. Populates myarray
2. chart.chartdata = myarray
3. at this point myarray(1,1) = chart.ChartData(1,0); myarray(2,1) = chart.Chartdata(2,0) and so on....
MyCODE:
1. Populates myarray
2. chart.chartdata = myarray
3. at this point myarray(1,1) = chart.ChartData(0,1); myarray(2,1) = chart.Chartdata(1,1) and so on....
I know it is a confusing question, but that just about sums it up for me. I am having a very difficult time charting these data points!
Thanks for ANY help,
Ron