I have a passage where i go as follows.
[VBA]
ac.SeriesCollection(1).XValues = .Range(.Cells(1, 1), .Cells(9, 1))
ac.SeriesCollection(1).Name = "first"
ac.SeriesCollection(2).Name = "not so first"
[/VBA]
Is there a way to assign the names as a whole set (array?) instead of, as shown above, going data set by data set? How?
Also, question number two. How important is it to assign .XValues to each of the data sets? It will be the same range anyway and as far i can see, it works with only one assignment.
On the other hand, once it seemed to be a good idea to use anti-pesticides. Later on they turned to cause deformations on babies. I don't want to deform my soon-to-be child by bad coding, you see...