Reducing Data Points in X-Y Scatter Graph

[Scott Barnhill]

I have a series of data each with over 1000 points of data. I want to be
able to pick the entire data set, but only plot say 200 to 300 hundred of
them. I know I have done this, but I cannot find it. Isn't there a way to
tell Excel to plot every so many other points?

 

[Jon Peltier]

Scott -

Here's one way:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Scott Barnhill]

Thanks! That works. I was hoping that Excel would have that built in the
charting options. I thought I had seen it before, but it may have been
another program.