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

Ayesha

"bj" wrote:

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

"Ayesha" wrote:

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