Reduction of data points used for a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have exported a large number of data points from a chromatography data collection program into Excell. I have about 12000 x,y points. (Time versus milliVolts
How can I reduce the amount of data points before making a chart? I would like, for example, to use only every tenth point for the chart.
 
Ole -

Suppose your data is in column C, starting in C2. In D2, put this formula

=OFFSET(C$2,(ROW()-1)*10-1,0)

And drag it down as far as you need. This puts the 10th, 20th, etc,
points into column D. If you're plotting X-Y data, you need to do this
for both X and Y. Use this new data for the chart.

- Jon
 
Back
Top