Plotting a graph with every nth cell

[davyj93]

Hi guys,

I am trying to plot a graph but I have a lot of data. I have 213,792 rows of data but Excel only lets you plot 32,000 data points on a graph.

How do I plot every 7th row of data instead?

Below is a small look at what my columns look like (and the rows would be filled in of course):

Time (mins)	Engine Power (kW)

<tbody>
</tbody>

Thanks,
David

 

[gaz_chops]

As per my explanation, row(A1) refers to row1 so 1X7-7, as you drag the formula down it changes to row2 2X7=14, row3 3X7=21 etc

 

[davyj93]

Ah ok. That makes more sense.

It seems to be working now.

Thank you.