I am collecting data readings from a kiln on a daily basis. I have 10 measurements in each of these daily records some of which are entered data and some of which are derived.
I would like to have a day by day line for one of the measurements for each of the samples (so there would be 10 different graphs with 8 lines each.) Alternatively, I’d like to have a day by day line charts for all of the measurements for one of the samples (so there would be 8 different graphs with 10 lines each.)
So either there needs to be a way to graph data from elements which are separated by n rows or m columns, or there needs to be a way to copy data that is separated by n rows or m columns into a compact array. Obviously, I could do this last method manually but this would be very labor intensive and error prone as the real records can cover as many as 150 days rather than the 3 days in the attached example.
Bookmarks