Less points in graph

N

Noga

Hello,
Is there a way to lessen the number of data points on the graph?
I would like to pick the entire column for the function, but to see in
the plot only part of the point.
Is it possible?
Thanks,
Noga
 
B

Bernard Liengme

No but something close it.
Suppose your x-values are in A2:A201, and y-values in B2:B201
In C2 enter =IF(MOD(ROW(),5)=0,B2,NA())
Copy down to C201
Select A1:A201; hold CTRL and select C1:C201 and make chart
You will see every fifth data point
best wishes
 
Top