New to Excel:

Help you with that.

a) How to make an average of column 3
To calculate the average of column 3, you can use the AVERAGE function. The syntax for the AVERAGE function is
=AVERAGE(range)
Example1:
1. Click on the cell where you want to display the average.
2. Enter the formula `=AVERAGE(C2:C1000)` if your data is in rows 2 to 1000 or `=AVERAGE(C:C)` if your data is in column C.
3. Press "Enter" to calculate the average.

Example2:
Where range is the range of cells that you want to average. In your case, the range would be the cells in column 3. So, the formula would be:
Code snippet
=AVERAGE(C2:C9)
This formula would average the values in cells C2 through C9, which are the values in column 3.

b) How to make a graph of the values relative to date and time
To create a graph of the values relative to date and time, you can use the LINE chart type. To do this, follow these steps:
1. Select the cells in columns 1 and 3.
2. Click on the Insert tab.
3. In the Charts group, click on the Line icon.
4. Select the Line with Markers chart type.
The graph will be created and will show the values in column 3 relative to the dates and times in column 1.

Here are the steps in detail:
1. Select the cells in columns 1 and 3. This will select the date, time, and value cells.
2. Click on the Insert tab. This will open the Insert ribbon.
3. In the Charts group, click on the Line icon. This will open a drop-down menu of different chart types.
4. Select the Line with Markers chart type. This will create a line chart with markers for each data point.
The graph will be created and will show the values in column 3 relative to the dates and times in column 1. The markers will help you to see the individual data points.

Harald0102 

See the attached sample workbook with some dummy data.