Excel Error Message

[bincempaka]

Hello.
When trying to create a chart with information trending over a long period of time I keep receiving this error message:

"The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series."

What can I do to stop this error? Please help.

Regards

[gmr4evr1]

1 or more of your data series has too many data points (the data you are plotting). You have to create more series, as the message says, or use less data points.

[Tom-tom]

Hello,

Since Excel will not be able to plot so many data points with any precision visible to a human eye, there is no point in including tens of thousands of data points in a chart.
You may want to extract every 5th or 10th value from your data and then chart only these.
If your data is in column A, with labels in the first row, you can use this formula (where D1 contains the value 5 or 10, to extract every 5th or 10th value)
=INDEX($A:$A,(ROW()*D$1)-D$1+1)
Also i recommend you to check several links:
https://www.fixtoolbox.com/excelfix.html
http://www.filerepairforum.com/forum...cel-2010-error

[bincempaka]

Thanks everyone for replies.