#1   Report Post  
Posted to microsoft.public.excel.charting
WG WG is offline
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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   Report Post  
Posted to microsoft.public.excel.charting
WG WG is offline
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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   Report Post  
Posted to microsoft.public.excel.charting
WG WG is offline
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide and unhide a serie matelot Charts and Charting in Excel 3 May 9th 07 01:26 PM
Format serie of numbers Norm Gregoire Excel Worksheet Functions 5 February 12th 07 04:18 PM
Pack data columns into one serie only N! Xau Excel Discussion (Misc queries) 0 November 15th 05 09:42 AM
Removing a serie in a chart Renaud Charts and Charting in Excel 1 May 31st 05 03:03 PM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"