skip data points in graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I want to plot a x-y graph in Excel with 100 data points, is it possible
to have Excel automatically pick every 10th point (for example). I know I
can manually choose every 10th point, but can Excel do it just by clicking a
box or something?

Ayesha
 
Hi BJ,

Didnt try, was just wondering.

Can one use such an array formulas which would return only every 10th
address and pass this result in to the series formula.

Thanks a lot,
Hari
India
 
if you are going to use a different data set
you could use something like
(if your data were say in B21 to B221
enter in G1)
=indirect("B"&(21+(Row()-1)*10))
and copy down to G21
this would give you a set of the data points form every 10 positions

I am nor sure of an Array formula which would do it for you.
 
Sorry, how do I do that? Using the "advanced filter" option? How do I set
it up to up every 10th row?

Ayesha
 
Back
Top