Plotting every Xth point only

  • Thread starter Thread starter JMcG
  • Start date Start date
J

JMcG

Hi,

I have some very large data sets which I wish to plot.
This however produces very large (and not very pretty)
graphs (my data set consits of points every 0.1 seconds
for 1 hour).

To get around this I want to plot only every 25th (or
10th, or 50th) point. e.g. if my data set was
{1,2,3,4,5,6,7,8,9,10,11,12} and I wanted to plot every
3rd data point I would plot {3,6,9,12}.

Does anyone know how I can do this in Excel?

Thanks,
JMcG
 
Oops, that one was deleted

X values in A1:A1000
Y values in B1:B100
in C1 enter =IF(mod(row(),5)=0,B1,NA())
copy down to C1000
plot A1:A1000 with C1:C1000 (select non-contiguous ranges using CTRL key)

hope this is OK. Get back to me if too terse
 
If what you want to do is plot all the points, but only put symbols on some
of the points because of a high density of points, then my chartool addin
may work for you, www.xlrotor.com/chartool.zip

Cheers,

Brian Murphy
Austin, Texas
 
Back
Top