LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default plotting certain x points from a large data group

You can extract every 8th cell into a different (contiguous) range,
and use that secondary range as the data source for your graph. If
your data is in column A starting with A2 (allowing for headers), and
you want to get A2, A10, A18 etc in sucessive cells in column D, then
put this in D2:

=INDEX(A:A,(ROW(A1)-1)*8+2)

then copy down as required. You can have a similar formula in column E
(say) for your Y-values.

Hope this helps.

Pete

On Feb 25, 7:45*pm, znova wrote:
Is there a function or method to plot say every 8th point in the x data (time
stamp) column with many other columns of data that is to be plotted to the y
axis per the x (time stamp) data points..


 
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
Plotting NA() or #N/A data points Doug Charts and Charting in Excel 0 November 13th 09 09:14 PM
Plotting data points on 2 axis Nikhil Charts and Charting in Excel 4 April 27th 09 05:40 PM
Not plotting data points in a line chart NameDuJour Charts and Charting in Excel 1 November 1st 07 09:29 AM
Excel Incorrectly Plotting Non-sequential Data Points [email protected] New Users to Excel 6 June 20th 07 11:29 PM
Plotting two data points as one kraway Excel Discussion (Misc queries) 1 March 12th 07 08:38 PM


All times are GMT +1. The time now is 06:56 PM.

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"