|
| 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
June 8th, 2007, 07:59 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
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
June 8th, 2007, 12:46 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 8th, 2007, 01:55 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 8th, 2007, 02:42 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 8th, 2007, 10:04 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 11th, 2007, 10:32 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 12th, 2007, 06:03 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 20th, 2007, 12:32 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 20th, 2007, 08:22 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
June 25th, 2007, 03:19 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 | |
|
|
Linear Mode
