Just wondering if there was a way to create a macro which could take a column of data and plot it and then move on to the next column and do the same?
Each sheet has a different number of lines so i know i would have to somehow make the range from the second line to the last line. But i'm unsure as to how to loop through columns as well as lines.
My current sheet has 9 columns, the first is just samples and the 2nd to 9th is the data i need to put into separate line charts. (So one graph for column 2, one graph for column 3 etc)
Any help would be greatly appreciated.