I need to create a line chart from a number of samples in batches of 5. I need to plot every value in one line, not the average of the batch. I know I can do it if I input the values one after the other, downward
ie:A1:A10
My problem.
I want to line all the values in various cells ie:A1:C10 and then chart on the same line.
When I try this it will always give me aline for every cell.
Thanks.