Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

SeriesCollection object in Excel 2007 and 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mcleester - 19 Jul 2007 19:30 GMT
I created a program that in Excel 2007 that assigns an array to a new series
SeriesCollection.XValues and SeriesCollection.Values.  It then shows up on
the chart.  

In Excel 2003, there are apparently limits on how long the series
information can be.  Is there any fix from MS on this or a way around it that
doesn't involve referencing a data range on the worksheet?  It dynamically
adds series, and I'd prefer to not have them on the worksheet.  I have tried
transposing and still run into limits and get errors.  I have also tried
putting the in .xvalues as array(x(1), x(2), x(3), etc.).  That also ran into
problems.  

Any help is much appreciated!
Chad - 20 Jul 2007 16:58 GMT
I have had similar difficulties and tried loading the series as a string
"={22,13,19}".  You might consider using a hidden worksheet to store the
data.  

Chad

> I created a program that in Excel 2007 that assigns an array to a new series
> SeriesCollection.XValues and SeriesCollection.Values.  It then shows up on
[quoted text clipped - 9 lines]
>
> Any help is much appreciated!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.