Too many data points (Excel 2003)

Topic

New Reply

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

Reply | Quote

Replies

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:

=OFFSET($A$2,5*(ROW()-ROW($A$2)),0)

– 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:

=AVERAGE(OFFSET($A$2,5*(ROW()-ROW($A$2)),0,5))

– 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.

Reply | Quote

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

Reply | Quote

I will try both techniques.
Thanks to both of you

Reply | Quote