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