ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   plotting certain x points from a large data group (https://www.excelbanter.com/excel-discussion-misc-queries/257385-plotting-certain-x-points-large-data-group.html)

znova

plotting certain x points from a large data group
 
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..

Pete_UK

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..




All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com