I have a data set that is being produced daily and is outputted by a program into an excel spreadsheet. I would like to make an excel spreadsheet that makes a x-y scatter plot of the quantity of different items versus time with different lines for different sampling points. The data is outputted with time in one column, water quantity of different items in other columns, and the name of the sampling point in a third column (i.e. the sampling point column reads from top to bottom: "point 1, point 2, point 3, point 1, point 1...etc.", the data is not separated by sampling point).
How can I make a quantity of different items versus time with a separate line for each sampling point without dis aggregating the sampling points into different data blocks (i.e. all the data for point 1 together, point 2 together, etc)? I am adding data to this daily and I would like the graph to update automatically without having to go through the process of dis-aggregating it.
How can I make a quantity of different items versus time with a separate line for each sampling point without dis aggregating the sampling points into different data blocks (i.e. all the data for point 1 together, point 2 together, etc)? I am adding data to this daily and I would like the graph to update automatically without having to go through the process of dis-aggregating it.
