Less points in graph

  • Thread starter Thread starter Noga
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top