If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
max data serie
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 |
#2
|
|||
|
|||
max data serie
Make two identically formatted series, each with half the data.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
#3
|
|||
|
|||
max data serie
Sorry, but I need to put one graph with 65000 points in my charts
WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
#4
|
|||
|
|||
max data serie
So make THREE identically formatted series ...
-- David Biddulph "WG" wrote in message ... Sorry, but I need to put one graph with 65000 points in my charts WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com "WG" wrote in message ... 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 |
#5
|
|||
|
|||
max data serie
Why does it have to be one series?
Can you resolve 65k points on a chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... Sorry, but I need to put one graph with 65000 points in my charts WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
#6
|
|||
|
|||
max data serie
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" wrote: Why does it have to be one series? Can you resolve 65k points on a chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... Sorry, but I need to put one graph with 65000 points in my charts WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
#7
|
|||
|
|||
max data serie
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message news 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" wrote: Why does it have to be one series? Can you resolve 65k points on a chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... Sorry, but I need to put one graph with 65000 points in my charts WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
#8
|
|||
|
|||
max data serie
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 "Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message news 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" wrote: Why does it have to be one series? Can you resolve 65k points on a chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... Sorry, but I need to put one graph with 65000 points in my charts WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
#9
|
|||
|
|||
max data serie
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 "Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message news 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" wrote: Why does it have to be one series? Can you resolve 65k points on a chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... Sorry, but I need to put one graph with 65000 points in my charts WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
#10
|
|||
|
|||
max data serie
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 "Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 "Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message news 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" wrote: Why does it have to be one series? Can you resolve 65k points on a chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... Sorry, but I need to put one graph with 65000 points in my charts WG "Jon Peltier" wrote: Make two identically formatted series, each with half the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "WG" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|