This is a two part question
I have a 2D array, say TheArray(1 to 365, 1 to 1000) say 365 days in year and 1000 trees. The data input is the number of fallen leaves. I would like to:-
1 - perform calculations on the data in rows. eg say row 1 is january first would like to find average number of fallen leaves.
2 - would like to put data from array into a chart/histogram, but not sure how to do that without actually printing the whole array into a worksheet and then using cell references (which I feel is lenghty)
thanx
zviito
p.s the tree and leaf thing is just an example I am not really doing this.....
I have a 2D array, say TheArray(1 to 365, 1 to 1000) say 365 days in year and 1000 trees. The data input is the number of fallen leaves. I would like to:-
1 - perform calculations on the data in rows. eg say row 1 is january first would like to find average number of fallen leaves.
2 - would like to put data from array into a chart/histogram, but not sure how to do that without actually printing the whole array into a worksheet and then using cell references (which I feel is lenghty)
thanx
zviito
p.s the tree and leaf thing is just an example I am not really doing this.....