Reduction of data points used for a chart

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Ole Hansen wrote:

> 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.