Data Frequency
Kyle wrote:
Hello, I have over 100,000 data points. I would like to do a scatter plot of
every 10th or 100th point. What is the best way to accomplish this task?
You could copy the data to a separate range for charting. Use a formula
like
=MOD(ROW(),100)
then filter on the new formula column for any single value to see every
100th row, copy visible cells, paste elsewhere, and chart.
|