LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Plot or extract every 10th or 20th pair of values from 33,000 poin

I have 33,000 pairs of values from a logger.
- Time, concentration
How do I plot (or extract) every 20th value (or some other defined interval)?
Any ideas please (macro, VBA NOY manual selection).

I have tried past link row1, row10, row20 and dragging to extend the range
but this gives me row1, row20 row30 row2 row21 row31 etc

I want to end up with
row 1 data
row10 data
row 20 data

etc

Thanks. mel
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plot every 10th pt Jeff Charts and Charting in Excel 1 May 18th 06 03:58 PM
How do I show values of data points in a chart with the mouse poin warndt Charts and Charting in Excel 0 March 3rd 06 05:58 PM
etsimate values of a linear trend for each pair of known values Maarten Excel Discussion (Misc queries) 2 January 15th 06 09:04 PM
Extract Unique Values, Then Extract Again to Remove Suffixes Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM
in excel, how do I find which values doesn't have a pair? jackies_place Excel Discussion (Misc queries) 2 December 17th 04 05:43 PM


All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"