+ Reply to Thread
Results 1 to 6 of 6

drawing chart from an array with more than 255 data point

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    iran
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question drawing chart from an array with more than 255 data point

    Hi to everybody
    I want to draw a scatter chart from an array but unfortunately it's not possible to draw more than 255 data point by this way
    I use need to use this method(drawing chart from array) because drawing time is very important for me and need to update the chart about ten times per second! so it's not a good idea to transfer data to cells before drawing chart
    I would be very thankful if any one suggest a better idea!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: drawing chart from an array with more than 255 data point

    Why the rapid update. What information can the user get from something that is changing so much?

    The 255 limit is for data series.
    There is a limit on the length of a SERIES formula. Does your arrange of data contain floating point values?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-11-2012
    Location
    iran
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: drawing chart from an array with more than 255 data point

    I need a horizontal line moving up and down on the main chart with a scrollbar moving up an down by user, so I used series to draw the line(different X and same Y) and update the Ys each time user moves the scrollbar to make a live movement!
    I used this code:

    Please Login or Register  to view this content.
    xdade and ydade are array variables containing 1000 datapoints but when I check the chart, there is just 255 datapoints
    when I open select data interface to edit series, I got this in series y value field(exactly 255 datapoints):

    Please Login or Register  to view this content.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: drawing chart from an array with more than 255 data point

    Please take a few minutes to read the forum rules about cross-posting.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    11-11-2012
    Location
    iran
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: drawing chart from an array with more than 255 data point

    Quote Originally Posted by shg View Post
    Please take a few minutes to read the forum rules about cross-posting.
    sorry about that!
    It would not happen again

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: drawing chart from an array with more than 255 data point

    You might find you get more data points if you reduce the precision of the values.

    Why not use cells to hold the values and named ranges to adjust the cells plotted. This can all be linked to a activex scrollbar and done without any vba code.

    Please include link to your x-post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1