number of series points per chart

[Klaus Mewes]

Anyone,
Is there a way to increase the maximum number of data
series per chart from the 255 limit?

[S...@internet.org]

Do you mean "number of data series per chart" or
number of points in a data series (as understood
from your title)?

For XL2K, one can only have 255 series in one chart.
The number of points for data series in a 2D chart is
32K, and for 3D charts is 4K. However, the absolute
number of data points in one chart (all series combined)
is limited to 256K.

What kind of data are you charting that requires such a
large number of series? If you share this information,
perhaps someone will be able to suggest alternate
graphical presentations in Excel that may suffice.

Sam

"Klaus Mewes" <me...@emory.edu> wrote in message
news:1353d01c1259a$2c79b6d0$b1e62ecf@tkmsftngxa04...

[John Walkenbach]

I wasn't even aware of this limit. But I would certainly guess that it
cannot be increased (I don't know of any "limits" in Excel that can be
overridden).

I'm curious about why you would need so many series.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

"Klaus Mewes" <me...@emory.edu> wrote in message
news:1353d01c1259a$2c79b6d0$b1e62ecf@tkmsftngxa04...

[S...@internet.org]

Typing "specification" in the answer wizard/office
assistant, then clicking Microsoft Excel specifications
yields a menu of links full of interesting tidbits (XL2K)
for Workbooks and Sheets including Pivot Tables,
Charts, and Workgroups.

- Sam

"John Walkenbach" <jo...@j-walk.com> wrote in message
news:e0rMXJaJBHA.1516@tkmsftngp03...

[Jon Peltier]

In article <e0rMXJaJBHA.1516@tkmsftngp03>, John Walkenbach asked...

>
>I'm curious about why you would need so many series.
>

I would think it would be impossible to interpret.

- Jon

[Klaus Mewes]

Thanks for the reply.
I would like to answer John Walkenbach's question also
here.
First I meant to say 'number of data series per chart'.
I am plotting data points by Excel-Macros which are
executed from Labview (National Instruments) via ActiveX.
I am plotting just one point per series. I haven't found
a way to program the VB macro so that it would plot more
than one point, i.e. 'add' to an existing series. Somehow
it seems a lot easier to just plot a new series than
to 'add' to an existing one. If anyone has a suggestion on
how to do this (source example, etc.) please let me know.
I can also supply some of the macro source code that I've
written as reference, if necessary.
Thanks Sam and John for your help,
Klaus--

>.
>

[S...@internet.org]

"Klaus Mewes" <kme...@mediaone.net> wrote in message
<SNIP>

I haven't found
| a way to program the VB macro so that it would plot more
| than one point, i.e. 'add' to an existing series. Somehow
| it seems a lot easier to just plot a new series than
| to 'add' to an existing one. If anyone has a suggestion on
| how to do this (source example, etc.) please let me know.
| I can also supply some of the macro source code that I've
| written as reference, if necessary.

<SNIP>

Klaus,

In Excel, record the following.

Copy a range you wish to add as points to an existing
series. Select the chart, and from the menu bar select
Edit -- Paste Special. You will be presented with options
to paste as new series or as new points. Like all recorded
code, you will need to edit and streamline the result.

Sam

[Klaus Mewes]

I have now changed my macros to plot new data series and
paste additional points as needed into each data series as
needed. What I am doing is dynamically adding new points
(depth information read from an encoder) to a data series,
one point at a time. For new segments I create a new
series.
This works fine for the first series and the first point
of the second series. When I plot the second point of the
second series, however, the series are getting linked
together so that sries one is expanded by the second point
of series two and all following points.
This also happens when I copy and pastespecial points from
the spreadsheet manually (not by Macro). I think I have
discovered a 'bug' in Excel. Can you confirm this? Give it
a try.
Best regards and thanks,
Klaus--

>.
>

[Tushar Mehta]

See the response in the other discussion that you started on the same
subject.

--
Please don't post separate articles on the same subject to one or
multiple newsgroups. All that it accomplishes is to fragment the
responses that you receive, effectively wasting the resources that make
these newsgroups what they are. You may want to review the 'Hints and
Tips' page at www.cpearson.com/excel/newposte.htm

Regards,

Tushar Mehta
www.tushar-mehta.com
--

In <15e9301c1334f$58a44c80$9ee62ecf@tkmsftngxa05>, Klaus Mewes
<me...@emory.edu> wrote