max data serie

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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
 
Yes, that's what I meant when I suggested splitting the series into parts.

Nice display. If you don't need to output the charts in black and white in a
report-sized format, then you can ignore my question.

- Jon
 
I don't need to print my charts.
The code in VBA is a Rung Kutta simulator.
Each graph represent a window of 300µs (30K x 10ns, clock 100 MHz fixed)
and actually to see 10 ms it represent 30 graph and it's difficult
to have a good around vision of the simulation.
What I need is to make charts of 100K (one serie), each graph represent 1 ms
10 x.
To do that, i need that the input of your chart object is a array
Tab (1 To 100000, 1 To N) and not use the set source data method with cells
limited by 65K.....
Can you help me ?
WG
 
Back
Top