| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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 ... 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
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 ... 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
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 ... 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
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 ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide and unhide a serie | Charts and Charting in Excel | |||
| Format serie of numbers | Excel Worksheet Functions | |||
| Pack data columns into one serie only | Excel Discussion (Misc queries) | |||
| Removing a serie in a chart | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Linear Mode
