Creating Chart (Line) using Array data, not ranges.

Hi,

i have created a 1-D Array containing 2-D worksheet ranges in its indexes, pulled from sheets data from an external workbook. right now i am manipulating required values in it and pasting it to a hidden sheets (60) from which i create line charts on a dashboard. since the data is large and referencing each hidden sheet i have to create multiple charts on dashboard, this is not a feasible option.

what i want to do is to find out an alternative option i.e. :
1] no hidden sheets anymore.
2] just have Array to create the charts.

so my simple question is, is it possible to create a chart using not worksheet ranges, but array values?

Yes you can create charts without actually using the data sheet. The values will have to be directly passed on to the series source.

Hi

You may find this link useful: http://www.excelfox.com/forum/f12/ma...ing-arrays-14/

Thank you both for your solutions. this is really helpful :)