Create chart using data array (not range)

Hey guys,
I have the following sub and I want to create a chart by reading data from array. Because I don't want to have data in worksheets. However, the sub doesn't work if the array is too big (when n>55).
Can somebody help me? I appreciate your help!

But I don't think there is a way to solve this problem without 'printing' the numbers to the worksheet first.

Please Login or Register  to view this content.

Welcome to the forum, Pingu.

Please take a few minutes too read the forum rules, and then edit both of your posts to add code tags.

As you have discovered the SERIES formula has a finite length limit.

See this page on ways to reduce the length of the array of values.
http://peltiertech.com/Excel/ChartsH...ChartData.html

You will save yourself a lot of heartache if you just use a worksheet to store the values. Hide the worksheet if you don't want the user to see it.