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

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

--
Regards,
Tom Ogilvy


" wrote:

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

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

http://pubs.logicalexpressions.com/P...?ID=209#jon024

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


wrote in message
ups.com...
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