skip data points in graph

[Ayesha]

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

 

[bj]

since excel only plots visible cells
use a filter to select and show only evey tenth row.

 

[Hari Prasadh]

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

 

[bj]

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.

 

[Jon Peltier]

An array formula could work, but I don't have time to think of an example.

The Microsoft Excel Charting FAQs has more on decimating data:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Ayesha]

Sorry, how do I do that? Using the "advanced filter" option? How do I set
it up to up every 10th row?

Ayesha