Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Too many data points (Excel 2003)

    I have more than 38,000 data points that I would like to chart. The maximum number of data points in Excel 2003 seems to be 32,000. Does anybody have an idea on how best to handle a situation like this? How could I just chart every 5th point?

    Thanks,
    itconc

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Too many data points (Excel 2003)

    Let's say your data are in column A, starting in A2:
    If you'd like to plot every 5th point:
    - Enter the following formula in another cell in row 2, say in C2:
    <code>
    =OFFSET($A$2,5*(ROW()-ROW($A$2)),0)
    </code>
    - Fill down as far as needed for 1/5th of the number of data points.
    - Create a chart based on the new column.
    - You can change 5 to another number of course.

    You could also take the average of every (say) 5 data points:
    - Enter the following formula in another cell in row 2, say in C2:
    <code>
    =AVERAGE(OFFSET($A$2,5*(ROW()-ROW($A$2)),0,5))
    </code>
    - Fill down as far as needed for 1/5th of the number of data points.
    - Create a chart based on the new column.
    - You can change 5 to another number of course.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Too many data points (Excel 2003)

    If you use the Office Web Components you can put a chart on a userform and display more points (I just tested with 40000 and it will do it, though the chart is a little cluttered!!)
    FWIW
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Too many data points (Excel 2003)

    I will try both techniques.
    Thanks to both of you

Posting Permissions

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