X,Y Plot Excel Question

Im sure there is an easy way to do this, but in Excel (specifically the 2010 version) Is there a way when selecting data for an X,Y scatter plot to select every like....15 or X pieces of d开发者_如何转开发ata

So like pretend I was selecting a huge column for a list for the X points, is there a way to do EVERY 15...instead of just all. Because sometimes I have a thousand data points and I can't click every 15 lol that'd take forever.

Thanks

Next to the data, add a column containing =IF(MOD(ROW(B1),15)=0,1,0)

Select the rows which have 1 in this column

Cut/paste elsewhere

Plot them