Plotting every Xth point only

[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

 

[Bernard Liengme]

See example at www.stfx.ca/people/bliengme/ExcelTips

best wishes
Bernard

 

[Guest]

Sorry, can't see the example. Can you be more specific?

JMcG

 

[Bernard Liengme]

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

 

[Jon Peltier]

You could check this article on dynamic charting. The last part of it
shows how to vary the plotted frequency of the points.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Tushar Mehta]

See Select Markers
http://www.tushar-
mehta.com/excel/newsgroups/only_some_markers/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[JMcG]

That's great - thanks

JMcG

-----Original Message-----
See Select Markers
http://www.tushar-
mehta.com/excel/newsgroups/only_some_markers/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions


.

 

[Tushar Mehta]

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

That's great - thanks

JMcG

{snip}

 

[Brian Murphy]

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