Chart source data

Hello,
In my VBA code, I calculate a matrix M of dimension (x, 1) where x is a variable number. Now I want plot M in a x-y graph. How can I source the data from the matrix? Searching on internet I found the command SetSourceData, but it requires as input a range, like:

Please Login or Register  to view this content.

There is a way to source the data for the graph directly from M?

Without seeing a sample of what you are trying, I find it difficult to help with a solution. Sometimes the easiest way to get what you are searching for in VBA is to manually record the macro while building the chart. Have you tried this?

SetSourceData does only work with ranges. You need to assign the array to the Values property of the relevant series, but be aware that there is a limit to the length of the formula you can assign to a series and your values will be part of the literal formula. It's generally safer to just assign the array to a range, and then use that for the chart.

A graph can only source data from worksheet cells. Chart SERIES formulas require cell ranges (or named ranges) as arguments. There is no other way to build a chart. You will have to write your matrix to a worksheet then use the first line of code you showed to build the graph from that range.

BTW you said x is a variable number but your example shows 9 hard-coded, so my example is also hard-coded.

Please Login or Register  to view this content.

where Sheet Name is the name of a worksheet that you arbitrarily pick to store the data. It can be hidden.

rorya has a possibility that I overlooked which is putting the array of values directly into the SERIES formula. However, IMHO it is better to put the data in a worksheet.