Excel Error Message
Hello everyone!
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?
Regards
Excel Error Message
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)
This issue is also disscused here
https://social.msdn.microsoft.com/Forums/en-US/460af861-9a5f-4661-896a-b...
Excel Error Message
Thanks for reply!