I have a worksheet that lists every day so I can see if any tests were performed that day. If there were tests, then the average and standard deviation of that day show up in the next two columns. I also break up the days by adding rows of weekly averages.
I need to make a graph that only graphs the days averages and will automatically update if any new information is put in. As I understand it I can not use the OFFSET function because my information is not in a continuous line. The only solution I can think of is to filter out all of that information in a chart that automatically updates when new information is entered in the original worksheet, which will in turn update the graph.
How can I do this?