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

[Junoon]

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?

[Excel Fox]

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

[Admin]

Hi

You may find this link useful: http://www.excelfox.com/forum/f12/making-histogram-chart-using-arrays-14/

[Junoon]

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