Hi,
I hope this question has not been posted before.
I would like to plot a table using three data ranges that I already have on my spreadsheet.
I have 3 temperature data sets; 2 sets from upstream and one set from downstream.
I would like to plot three different lines on my graph:
-the downstream temp.
-the mean of the two upstream temps + the standard deviation time 3.
-the mean of the two upstream temps minus the standard deviation time 3.
My problem is that I want to do this without having to pre do the calcs on my spread sheet. I want to keep it all very neat on still only have the three data sets on display.
Could I do this in a macro?
the point of this would be to be able to visually see when the downstream temp fall out of the given boundary.
I hope I have explained this clearly.
thanks in advance for any help or advice.
Bookmarks