How to Reduce the Number of Data Series Markers

[professorplum101]

I am writing some vb code for an excel "program" that will
automatically plot a lot of data. Does anyone have any code that I
can use to reduce the number of markers that will be plotted on the
screen for each series so that (1) the screen will refresh faster and
(2) each series will be identifiable. Right now, we are talking about
plotting up to 32,000 data points for each series. The number of
series and number of data points is known. Thanks.

Regards,
Brian Reeves

 

[Guest]

with that many datapoints, do you even need markers? Or is your data vary
random?

 

[Jon Peltier]

Here's one way to plot fewer points. Basically it means plotting a second
series with many fewer points:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024

- Jon