# Excel data plotting

1. ## Excel data plotting

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.

2. ## Re: Excel data plotting

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

3. ## Re: Excel data plotting

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.

4. ## Re: Excel data plotting

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

There are currently 1 users browsing this thread. (0 members and 1 guests)