max data serie

[WG]

Hi,
I use VBA in Excell, and I need to put more than 32000 points per graph.
Is it possible to make it ?
In excel you have 65537 lines, more than 32767.....
Thanks for your reply

 

[Jon Peltier]

Make two identically formatted series, each with half the data.

- Jon

 

[WG]

Sorry, but I need to put one graph with 65000 points in my charts
WG

 

[David Biddulph]

So make THREE identically formatted series ...

 

[Jon Peltier]

Why does it have to be one series?

Can you resolve 65k points on a chart?

- Jon

 

[WG]

Because the X-axis is the time, and the step-time is fixed by the clock of
electronic card.
Actually,Textronix scope send file (cvs format) of a shot of 1M points, one
serie...
When I see the actual one serie, 32K points, we can, if it was possible by
Excel, to 5x time more points one serie without problems.
2x time more, it's a beginning.....
W.

 

[Jon Peltier]

But you can easily split the incoming data into bite-size chunks.

You didn't answer my second question:
Can you resolve 65k points on a chart?

- Jon

 

[WG]

Sorry for the delay, I was in travel.
I suppose, when you say bite-size chunks,sorry for my bad english,
that you mean split my 60k one graph, one serie in 2 30k serie and draw 2
graph.
For the resolution of a graph with 65K points, in my opinion there is no
problem
(display of 20").
WG