Wierdness when adding data in serieses to x-y charts using V
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Wierdness when adding data in serieses to x-y charts using V

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Cambridge, UK
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am calling a function that ReDims and array and loads it with data from a worksheet.

    I am then creating a new series on my graph:

    dim pNewSeries as Series
    pNewSeries = Charts("MyGraph").SeriesCollection.NewSeries

    and loading it with my arrays:

    pNewSeries.Values = DynamicArray1 pNewSeries.XValues = DynamicArray2

    This works fine, but only if the number of points in my arrays is no greater than 14.

    What on Earth is going on?!!


    LLoyd

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Lloyd,

    There is a limit to the size of an array that you can assign to the Values or XValues properties. Unfortunately, Microsoft does not document many of these limitations in the helps. In the past when I have wanted to plot data from a large array I have had to write it to a worksheet and assign the Values and XValues properties to the corresponding worksheet ranges. Of course, all of this can easily be done from within VBA, and the data can be written to a hidden worksheet so the worksheet functions as a pseudo-array.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com