To give an example, I have the following matrix array that is named matrix_1 and located in cells A1 through D4

10 20 30 40
50 60 70 80
11 21 31 41
51 61 71 81

I know that if I name column 1, for example, column_1, I can plot it in a chart by referring to it as =my_book.xlsm!column_1 in chart Series 1 box, then name and plot column_2 as =my_book.xlsm!column_1 in chart Series 2 box, and so on.

What I'd like to do, though, is rather than giving each column a name, name the entire matrix matrix_1 and then go to each individual series in a chart and simply say something like =my_book.xlsm!matrix_1(1) in chart Series 1 box and =my_book.xlsm!matrix_1(2) in Series 2 box and so on. I realize that =my_book.xlsm!matrix_1(1) is not the correct syntax, but hopefully you get the idea.

Is this possible to do? Part of the reason I'd like to do this is because I have hundreds of graphs that I have to keep track of with many series each, and it would save a lot of time if I could avoid naming each individual column of data.

Thanks.