Workaroung: data point limit?

  • Thread starter Thread starter derfrager
  • Start date Start date
D

derfrager

Hi!

i´m looking for a workaround to create 54000-data-point-chart in Excel 2007.

I got

Is there any possibility to deal with that 32000 data point limit?

regards
 
There may be reasons for plotting vast amounts of points, eg

Show peaks, outliers etc. The chart can be stretched across many screen
widths, formatting to small points, borders etc. Where neighbouring points
are expected to be similar, could make a 2 new series showing min/max of
every 100 points in the original set. Instead perhaps average every 100
points or plot min/max if outside expected deviation from the average.

A Scatter heat map. This can show very considerably more points within the
same area. Size it large, even over several screens, and format markers to
minimum size. To overcome the 32k limit split the data into multiple series
(eg 2 x 25k), format each series to look the same (if you want).

Regards,
Peter T
 
Back
Top