# Thread: Too many data points (Excel 2003)

1. ## 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. ## 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. ## 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

4. ## 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
•