01-14-2010 09:15 PM
01-14-2010 11:00 PM
Why are you turning your array into a matrix? A matrix is not the same thing as an array. (They are related, but are not truly the same thing.)
Turn on context help and read about all the inputs into the charting function. You want to have a 2-D array. You are actually only starting off with a 1-D array. (Which you can't transpose if you wanted to because it is only 1 dimensional). Create a 2-D array of data to feed into the charting function. If you need to transpose that you can. Don't play with matrix transformations, they are rarely used and only for special math operations when they are. Wire up any other inputs to the charting function as needed. The default chart type is xlColumnClustered which I am going to guess is not truly the graph you want. You probably want an XYscatter.
01-15-2010 10:21 AM