Plotting every Xth point only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JMcG - 24 Aug 2004 15:06 GMT

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

Reply to this Message

Bernard Liengme - 24 Aug 2004 16:11 GMT

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

best wishes
Bernard

> Hi,
>
[quoted text clipped - 12 lines]
> Thanks,
> JMcG

Reply to this Message

- 24 Aug 2004 18:00 GMT

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

JMcG

>-----Original Message-----
>See example at www.stfx.ca/people/bliengme/ExcelTips
[quoted text clipped - 20 lines]
>
>.

Reply to this Message

Bernard Liengme - 24 Aug 2004 21:54 GMT

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

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

> Sorry, can't see the example. Can you be more specific?
>
[quoted text clipped - 27 lines]
> >
> >.

Reply to this Message

Jon Peltier - 24 Aug 2004 22:15 GMT

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/
_______

> Sorry, can't see the example. Can you be more specific?
>
[quoted text clipped - 30 lines]
>>
>>.

Reply to this Message

Tushar Mehta - 24 Aug 2004 23:09 GMT

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

Signature

Regards,

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

> Hi,
>
[quoted text clipped - 12 lines]
> Thanks,
> JMcG

Reply to this Message

JMcG - 25 Aug 2004 12:17 GMT

That's great - thanks

JMcG

>-----Original Message-----
>See Select Markers
[quoted text clipped - 19 lines]
>>
>.

Reply to this Message

Tushar Mehta - 27 Aug 2004 16:08 GMT

You are welcome.

Signature

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}

Reply to this Message

Brian Murphy - 31 Aug 2004 15:43 GMT

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

> Hi,
>
[quoted text clipped - 12 lines]
> Thanks,
> JMcG

Reply to this Message