Plotting value vs. time every minute when data is available by the second

[Gahl42]

Hello,

I have a set of data from a real time piece of equipment sampled every 15 seconds. To go along with this I calculate various averages, rolling averages, rates of changes between each sample etc. On of the fields I calculate is an average value by the minute. I.e., I have 4 15 second interval data values I sum up divide by twelve, and put that value out for each whole minute. (Time is provided as actual time of day).

See sample data below (very simplified as many columns are no shown)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Recorded Value[/TD]
[TD]Average[/TD]
[/TR]
[TR]
[TD]00:00:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]00:00:15[/TD]
[TD]0.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:00:30[/TD]
[TD]1.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:00:45[/TD]
[TD]2.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:01:00[/TD]
[TD]3.5[/TD]
[TD]=(0+0.5+1.5+2.2)/4[/TD]
[/TR]
[TR]
[TD]00:01:15[/TD]
[TD]3.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:01:30[/TD]
[TD]4.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:01:45[/TD]
[TD]4.4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:02:00[/TD]
[TD]5.5[/TD]
[TD]=(3.5+3.5+4+4.4)/4
[/TD]
[/TR]
[TR]
[TD]...and so on[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I use a scatter plot to plot value over time, no problem.

I then wish to have a separate scatter plot to plot out the calculated average for the last whole minute. This is easy to do if I somehow generate a table only with the times and the associated average. I would however like to do this without doing any table editing or using dedicated tables. (There may be more average like on a 5 minute basis, 15 minutes basis, and hourly basis, that I will wish to plot).

Is there a way I could easily do a plot in just selecting the time column and the average value column and generate a scatter plot? I am not getting any graphs showing up doing so. Is there a way I can signify that only grab every 4th value and ignore rows with empty values for what will be my y-axis?

I should also mention I have several thousands of data points (rows).

Any suggestions appreciated.

 

[NiMip]

I had a go and the scatter plot showed exactly what you're after... only data points for where there was a non-blank cell. How do you mean you're not getting any graphs showing up?

 

[Gahl42]

I had a go and the scatter plot showed exactly what you're after... only data points for where there was a non-blank cell. How do you mean you're not getting any graphs showing up?

I see a plot area when doing this in my larger spreadsheet, but no graph is displayed. I've checked the ranges for the x and y axis to the data values, and a graph would fit nicely within the range, and not be hidden for example because of much larger scales than what the data represents.

When I double check the horizontal axis by selecting data source, I only see one x-axis (time) value. Yet the overall data range covers all 8000+ rows, which amounts to several hundred average values. It does not allow me to edit the horizontal axis data range.

I suspect there are some other issues going on my spreadsheet compared to what my simplified example may convey.

Thanks

 

[Gahl42]

Update: I was trying to plot only using straight line graphing (not showing the data points). Turns out I can get the data points to show in scatters that have this as an option, but not lines. I've checked various settings for line color, thickness, transparency etc., but cannot find what I am missing for a setting that would mean that straightline graphing between the data points do not show. (I don't want to see the data points as it gets to be a cluttered view).