Excel data plotting

[fathiarshad123]

I have an excel file with 3500 points. I need to plot a graph taking the average of every 100th point, so as to get a clear curve. it is a flux vs time curve.
so, the first point will be at 0s,0, then 100 s, ( and the average of first 100 flux values) then 200s, value of next 100 flux values and so on.

[davsth]

An attachment would make life easier as per the yellow banner, but would you plot as you describe? would 100s not be the average from 50-150 seconds?

The averageif formula will do what you want, but without data is hard to write a formula for you

[fathiarshad123]

Hi, thanks for your reply.
I have attached the file.
As you can see, there are too many data points. we need to plot a curve taking the average of every 100 points.

[davsth]

I would put
=AVERAGE(OFFSET(A$2,(ROW(A1)-1)*100,0,100,1))

as a formula and copy to the right one column and then down

it averages each group of 100 points, these can then be plotted as a scatter graph, although I am not sure it is a curve