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?