Thread: Data Frequency
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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.